Mysql connect errors

Hey, i'm having a problem with mysql

I'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
when i'm another user:

[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]$

Does anybody know why?!

 

 

 

 

Top