Hi,

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
Enter password:
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
Enter password:
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,?


Cheers!

Try logging in without using a password, like so:
It's usually a good idea to create user accounts rather than logging in as the default (root without password). For information on user management in MySQL, see here:
http://dev.mysql.com/doc/mysql/en/Us...anagement.html

You can download version 4.0 of MySQL here:
http://dev.mysql.com/downloads/mysql/4.0.html
You want "Linux x86 RPM downloads". Install them all once you've downloaded them using the command 'rpm -Uhv MySQL*rpm'.

Hi,

I create a normal user in mysql named "wangjunwei", when I login in Linux as my root account, I can get access to mysql with my normal mysql account "wangjunwei".
[root@so-19661-x0 wangjunwei]# mysql -h localhost -u wangjunwei -p
Enter password:
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>


But when I login my linux as my normal account, I can not get access to mysql database, do you know why?
[wangjunwei@so-19661-x0 wangjunwei]$ mysql -h localhost -u wangjunwei -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Hi,

Have you done this "mysql_enable=YES" in your configuration file ?