Connect to mysql as non root(linux) user
Cant connect to mysql as non root(linux) user.
Im using slackware 9.1 mysql is running, starts fine at boot. as the linux root user im able to connect, getting the mysql> prompt and then everything works fine. when im not root(linux) i get this error when i try to connect james@darkstar:~$ mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) james@darkstar:~$ i enter the correct password because it works when im the root(linux)user. any ideas anyone? |
Check your mysql db access. You might have granted access to your mysql DB from root but no other user. eg:
grant CREATE, INSERT, SELECT, DELETE, UPDATE on (your db).* to user@localhost; :) |
All times are GMT -5. The time now is 02:47 AM. |