[opensuse] Mysql cannot find /var/run/mysql/mysql.sock
Hi Folks! I hav a question with regard to mysql: I want to change the password, but everything i try with mysql brings out the same error: benji@linux-hy7i:~> mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) What is going wrong here? Actually the Deamon is already running: benji@linux-hy7i:~> ps -ef|grep mysqld benji 4974 590 0 17:40 pts/1 00:00:00 grep --color=auto mysqld benji 32740 32737 0 10:49 ? 00:00:22 /usr/sbin/mysqld --defaults-file=/home/benji/.local/share/akonadi/mysql.conf --datadir=/home/benji/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-benji.Du9H1E/mysql.socket Thanks for help!! Benjamin. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sunday, 2014-03-23 at 20:41 +0100, Benjamin wrote:
What is going wrong here? Actually the Deamon is already running:
benji@linux-hy7i:~> ps -ef|grep mysqld benji 4974 590 0 17:40 pts/1 00:00:00 grep --color=auto mysqld benji 32740 32737 0 10:49 ? 00:00:22 /usr/sbin/mysqld --defaults-file=/home/benji/.local/share/akonadi/mysql.conf --datadir=/home/benji/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-benji.Du9H1E/mysql.socket
That's not the daemon. Look at mine: Telcontar:~ # ps -ef|grep mysqld root 2763 1 0 Mar22 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --datadir=/var/lib/mysql mysql 3009 2763 0 Mar22 ? 00:00:45 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/Telcontar.err --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock root 29793 28315 0 21:35 pts/8 00:00:00 grep --color=auto mysqld Telcontar:~ # See? Yours is owned by your user, mine by root. Mine is the system wide daemon, your's is a local daemon used by KDE (akonadi). And it has a local config file, which you can see in your ps output. - -- Cheers, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iEYEARECAAYFAlMvRvIACgkQtTMYHG2NR9W4qgCghwGQhoFZA6tHDk9wCRPHC+Di EZYAn0zmuuCEByEXv/+4p82EuYOL7SuO =LgWi -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (2)
-
Benjamin -
Carlos E. R.