Page 1 of 1

set mysql permissions in suse 11.0(access denied for ...)

Posted: Mon Sep 08, 2008 3:53 am
by emab
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! :banghead:
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"