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"