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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
emab
Forum Newbie
Posts: 1
Joined: Mon Sep 08, 2008 3:41 am

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

Post 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"
Post Reply