MySQL access problem
Paco Ros
paco at bergantells.net
Thu Feb 23 22:11:10 UTC 2006
Hi all! :-)
I've got all mysql 5 related packages installed in a up to date dapper:
paco at blackbox:~$ dpkg -l "*mysql*" | grep ^ii | awk '{print $2}'
libdbd-mysql-perl
libmysqlclient12
libmysqlclient14
libmysqlclient15
mysql-admin
mysql-admin-common
mysql-client
mysql-client-5.0
mysql-common
mysql-query-browser
mysql-query-browser-common
mysql-server
mysql-server-5.0
php5-mysql
python-mysqldb
python2.4-mysqldb
I can create a user to access roundcubemail database (I've already created it)
as usually:
paco at blackbox:~$ sudo mysql
Password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.18-Debian_6-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT ALL PRIVILEGES ON roundcubemail.* TO rcm@'localhost' IDENTIFIED
BY 'password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
But I can't access to database:
paco at blackbox:~$ mysql -u rcm -p roundcubemail
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (13)
I've not found any log errors (neither syslog nor mysql.* logs).
I've also tried it by using "blackbox" (my hostname) and "%" (all hosts)
unsuccesfully.
Please, could anybody tell me what I am doing badly?
Thanks in advance for your help.
Kind regards.
--
Paco Ros.
More information about the ubuntu-users
mailing list