Mysql Connection Problems
Posted: 29. July 2009 04:55
I'm a little confused about sockets ....
When I bring up the "XAMPP for Linux" (the orange page) i get:
Access denied for user 'root'@'localhost' (using password: NO) in /opt/lampp/htdocs/xampp/cds.php on line 64
(Note: In xampp security, I did set a root password)
When I try: /opt/lampp/bin/$ mysql -s root ... I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
The "/opt/lampp/etc/my.cnf" file says:
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-locking
key_buffer = 16M
Any ideas? Please give detailed instructions ... I'm a newbie ...
Thanks
When I bring up the "XAMPP for Linux" (the orange page) i get:
Access denied for user 'root'@'localhost' (using password: NO) in /opt/lampp/htdocs/xampp/cds.php on line 64
(Note: In xampp security, I did set a root password)
When I try: /opt/lampp/bin/$ mysql -s root ... I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
The "/opt/lampp/etc/my.cnf" file says:
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-locking
key_buffer = 16M
Any ideas? Please give detailed instructions ... I'm a newbie ...
Thanks