Mysql connect errors
Hey, i'm having a problem with mysqlI'm doing all this from command line! (please don't tell me to get phpmyadmin - i'm doing this to learn)
I can only get into mysql if i'm logged in as root.
[root@asdfadmin]# mysql -u test -p vbull
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 54 to server version: 3.23.22-beta
Type 'help' for help.
mysql> quit
Bye
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 54 to server version: 3.23.22-beta
Type 'help' for help.
mysql> quit
Bye
[asdf@asdfadmin]$ mysql -u test -p vbull
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[asdf@asdfadmin]$
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[asdf@asdfadmin]$
Does anybody know why?!