set mysql permissions in suse 11.0(access denied for ...)
Posted: Mon Sep 08, 2008 3:53 am
Hi
I have installed LAMP server in linux suse 11.0!
in command line when i type "mysql mysql" i can't access Mysql! but when i switch to super user mode by "su" i can use "mysql mysql" to access it!
the problems starts here that when i want to test a code, which itself creates a table or changes a table in a database, i can't do that!
what should i do now?
(in my php codes i can read from databases)
Error that i recieve:
Access denied for user 'mysql'@'localhost' (using password: YES)
HOST:"localhost"
USER:"mysql"
PASS: ""
DB: "sth"
I have installed LAMP server in linux suse 11.0!
in command line when i type "mysql mysql" i can't access Mysql! but when i switch to super user mode by "su" i can use "mysql mysql" to access it!
the problems starts here that when i want to test a code, which itself creates a table or changes a table in a database, i can't do that!
what should i do now?
(in my php codes i can read from databases)
Error that i recieve:
Access denied for user 'mysql'@'localhost' (using password: YES)
HOST:"localhost"
USER:"mysql"
PASS: ""
DB: "sth"