feed all

مطالب مرتبط با «mysql» در feed all | نویسنده: استخدام کار

ubuntu 16.04 and mysql

All times are GMT +1. The time now is 02:29 AM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

[ubuntu] Ubuntu 16.04 mysql database

A new kick at the cat, the last effort came up short due to crap referenceshttps://hardcoregames.azurewebsites.net/?p=29892 is my manual for MySQL on Ubuntu 16.04 using the system disk for nowso now that the database is setup properly it seems to be working as desiredwith manual command line its not hard to use now, but I was hoping to maybe do more with it over time?new location and filename for the configuration is inconvenient but I have commented out the local host binding so I can use the database as a cloud applianceso what the best route for a small number of databases?any considerations for managing the size of the database?tools etc? Let's block ads! بخوانید...

ادامه مطلب

[ubuntu] stand alone mysql for cloud use

Recently I upped a Ubuntu 16.04 virtual machine, I get 768MB of RAM and 20GB of storage, my old IBM PC300GL has 768MB of memory but the disk was limited to 128GB (Azure is not so tight with storage and the CPU is way faster than the old Pentium III-733)sudu apt-get updatesudo apt-get upgradesudo apt-get install mysql-serverso my database is setup with a password, so I wanted to conjure some shell scripts so I can more easily make new database when I want to install a new web site etcdatabase and the vm are secured with good passwordsdatabase is to be a pure cloud appliancemaybe i can mechanize the service more?I am manually operating the VM with Putty nowI have a URL so I want to be able to ...

ادامه مطلب

Ubuntu server 14.04 JDK and JDBC connectivity to mysql

All times are GMT +1. The time now is 02:37 PM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

[ubuntu] Can't connect to Mysql

Hi ,I installed mysql server and client in my system. But i can't coect by usingsudo mysql -u root -pshows "mysql: unknown option '--EOF'"if i run$ps -ef|grep mysqlmysql 13197 1 0 16:13 ? 00:00:02 /usr/sbin/mysqldtrivand 13550 2180 0 16:28 ? 00:00:00 /bin/bash /usr/bin/mysql-workbenchtrivand 13553 13550 0 16:28 ? 00:00:00 /bin/sh /usr/bin/catchsegv /usr/bin/mysql-workbench-bintrivand 13555 13553 0 16:28 ? 00:00:07 /usr/bin/mysql-workbench-bintrivand 14920 10484 0 17:48 pts/4 00:00:00 grep --color=auto mysql$dpkg --get-selections | grep mysqllibdbd-mysql-perl installlibmysqlclient18:amd64 installlibmysqlcppco7 deinstallmysql-client installmysql-client-5.5 installmysql-client-core-5.5 installm...

ادامه مطلب

[server] MySQL eating all of my Memory

Hey guys, here again with another issue.I have a Ubuntu 16.04 ruing on a vps with 1GB of RAM. It has the basic LAMP stack and is hosing WordPress.The issue I'm having is that the MySQL daemon (mysqld) is eating my memory alive. After a clean boot, I would have about 300-350 MB remaining. Also available memory would drop by about 4 -20 MB with each page request. Then, when I kill mysqld, my RAM would jump from about 1-3MB (not a typo) to 700MB of available memory. Eventually so much memory get's used that I can't ssh into it, run "free -m -h", top, or even run a basic command from the web console (courtesy of the hoster). Eventually the server would start giving out 500 errors.Here is my mysq...

ادامه مطلب

mysql-server-5.7 failing to install (was marked as sercurty fix)

I wwnt to install updates, one of which was mysql, now the package is installed, but apt says it is not as it will not complete the instllation:oot@fileserver:/var/run# apt-get install mysql-serverReading package lists... DoneBuilding dependency treeReading state information... Donemysql-server is already the newest version (5.7.12-0ubuntu1.1).0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.2 not fully installed or removed.After this operation, 0 B of additional disk space will be used.Do you want to continue? [Y/n] ySetting up mysql-server-5.7 (5.7.12-0ubuntu1.1) ...Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.ser...

ادامه مطلب

Ubuntu secure MySQL by allowing only 2 servers to reach it

Hello.I own 3 servers, one is a MySQL server, one is a game server, and the third one is the web server. I have enabled remote MySQL, but due to security reasons, i'd like to use iptables to allow only those two servers to coect to MySQL (webserver and game server), how can i do this? Thanks in advance. Let's block ads! بخوانید...

ادامه مطلب

[ubuntu] A Mailserver on Ubuntu 16.04: Postfix, Dovecot, MySQL

All times are GMT +1. The time now is 11:52 AM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

[ubuntu] Problem with intializing MySQL Database.

Hi, I'm using Ubuntu 16.04 and used Code: sudo apt-get install mysql-server php-mysql to get MySQL server.Now, I was trying to initialize it by: Code: sudo mysqld --initialize-insecure OR Code: sudo mysqld --initialize It gives me this error: Code: 2016-06-05T18:24:48.573038Z 0 [Waing] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-06-05T18:24:48.580360Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting. 2016-06-05T18:24:48.582978Z 0 [ERROR] Aborting Let's block ads! بخوانید...

ادامه مطلب

Can not install mysql-client and mysql-server on ubuntu 16.04

All times are GMT +1. The time now is 08:02 PM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

[ubuntu] 16.04 MariaDB -> Error in syslog (mysqlcheck)

Code: May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: Looking for 'mysql' as: /usr/bin/mysql May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: Version check failed. Got the following error when calling the 'mysql' command line client May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) May 14 12:00:13 fortuna /etc/mysql/debian-start[1466]: FATAL ERROR: Upgrade failed May 14 12...

ادامه مطلب

ubuntu 16 mysql 5.7 reset root password

All times are GMT +1. The time now is 10:26 PM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

XAMPP mysql problem

All times are GMT +1. The time now is 08:22 PM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

[ubuntu] Installing mysql-server causes error

All times are GMT +1. The time now is 02:57 AM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

java and mysql packages

All times are GMT +1. The time now is 06:45 PM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب

MySQL datadir and systemd

It seems to be getting harder and harder to move the mysql database directory (datadir). A few releases back, apparmor came in the picture and I had to remember to go into /etc/apparmor.d/usr.sbin.mysqld and change the datadir there so mysql was allowed to use the new directory.Now with systemd there is apparently a script I have to modify. In order to get mysql to start I had to edit /usr/share/mysql/mysql-systemd-start and change the tests for the database directory to use the new directory.This seems like a clumsy way to go about this, so I'm wondering if there is some command that does this change for me. What is the recommended way to tell systemd where to look for the mysql database di...

ادامه مطلب

Postfix: Unsupported dictionary type: mysql on ubuntu 16.04

Hi! After upgrade to ubuntu 15.10 to 16.04 in mail.err - postfix/proxymap[35158]: error: unsupported dictionary type: mysqlpostconf -m | grep mysqlmysql existreinstall postfix-mysql and postfix not workpostconf -n Code: alias_database = hash:/etc/postfix/aliases alias_maps = hash:/etc/postfix/aliases allow_min_user = no allow_percent_hack = no biff = no body_checks = pcre:/etc/postfix/body_checks.pcre broken_sasl_auth_clients = yes command_directory = /usr/sbin content_filter = smtp-amavis:[127.0.0.1]:10024 daemon_directory = /usr/lib/postfix/sbin data_directory = /var/lib/postfix debug_peer_level = 2 debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd $daemon_directory/$...

ادامه مطلب

[ubuntu] cant start mysql

hellonot sure if this is the right place to create thread butIm using Ubuntu 15.04 and mysqltoday i found out that my mysql-server is inactivewhen im trying service mysql restart my terminal doesnt print anything, just ruing process without responsemysql status: Code: artesby@artesby:/etc/init.d$ sudo service mysql status -l [sudo] password for artesby: ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: activating (start-post) since Ср. 2016-04-27 23:07:43 MSK; 3min 51s ago Process: 20411 ExecStart=/usr/bin/mysqld_safe (code=exited, status=0/SUCCESS) Process: 20409 ExecStartPre=/usr/share/mysql/mysql-systemd-st...

ادامه مطلب

16.04 Unable to upgrade MySQL

All times are GMT +1. The time now is 03:44 PM.vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. Ubuntu Logo, Ubuntu and Canonical © Canonical Ltd. Tango Icons © Tango Desktop Project.User contributions on this site are licensed under the Creative Commons Attribution Share Alike 4.0 Inteational License. For details and our forum data attribution, retention and privacy policy, see here Let's block ads! بخوانید...

ادامه مطلب