Can not get access to mysql by normal user
I can not get access to mysql by normal user in my computer ( I can do it by root )
in the normal user's terminal, I type:
[wangjunwei@so-19661-x0 wangjunwei]$ mysql -h localhost -u root -p
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
How can I fix it?
It seems my Fedora2 use mysql 3.23.58, because it says:
[root@so-19661-x0 lib]# mysql -h localhost -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> Use mysql;
How can I upgrade to mysql 4.0,?