By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,497 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,497 IT Pros & Developers. It's quick & easy.

mySQL error

P: n/a
Hi, i am a beginner in PHP and mySQL.
Whenever I try to connect my php and mysql
database, i get this error.:
MySQL error : access denied for myuser@localhost (Using password:yes)

I have created a database called mydatabase at the SQLmonitor,
mySQL> create database mydatabase;

then i try to grant the access to mydatabase by
mySQL>GRANT usage on mydatabase.* to myuser@localhost;
mySQL>GRANT ALL PRIVILEGES on mydatabase.* to myuser@localhost;
mySQL>exit
mySQL>SET PASSWORD FOR myuser = Password('helloworld');
I modified the php file with the database username as myuser, password as
helloworld,
host as localhost, database name as mydatabase.

Please advice as to how i can avoid having problems of access denied above.
thank you.
zhen

Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I have the same problem
I try to improve the security on the mysql and now I can't get into it.
I get this massage.

“Access denied for user: '@localhost' to database 'mysql' ”

Is the same throw webmin or phpMyAdmin

Can anybody please help

I’m runnin Redhat 7.3 and mysql 3.23.56
/harly

c_chen wrote:
Hi, i am a beginner in PHP and mySQL.
Whenever I try to connect my php and mysql
database, i get this error.:
MySQL error : access denied for myuser@localhost (Using password:yes)

I have created a database called mydatabase at the SQLmonitor,
mySQL> create database mydatabase;

then i try to grant the access to mydatabase by
mySQL>GRANT usage on mydatabase.* to myuser@localhost;
mySQL>GRANT ALL PRIVILEGES on mydatabase.* to myuser@localhost;
mySQL>exit
mySQL>SET PASSWORD FOR myuser = Password('helloworld');
I modified the php file with the database username as myuser, password as
helloworld,
host as localhost, database name as mydatabase.

Please advice as to how i can avoid having problems of access denied above.
thank you.
zhen



Jul 19 '05 #2

P: n/a
I have the same problem
I try to improve the security on the mysql and now I can't get into it.
I get this massage.

“Access denied for user: '@localhost' to database 'mysql' ”

Is the same throw webmin or phpMyAdmin

Can anybody please help

I’m runnin Redhat 7.3 and mysql 3.23.56
/harly

c_chen wrote:
Hi, i am a beginner in PHP and mySQL.
Whenever I try to connect my php and mysql
database, i get this error.:
MySQL error : access denied for myuser@localhost (Using password:yes)

I have created a database called mydatabase at the SQLmonitor,
mySQL> create database mydatabase;

then i try to grant the access to mydatabase by
mySQL>GRANT usage on mydatabase.* to myuser@localhost;
mySQL>GRANT ALL PRIVILEGES on mydatabase.* to myuser@localhost;
mySQL>exit
mySQL>SET PASSWORD FOR myuser = Password('helloworld');
I modified the php file with the database username as myuser, password as
helloworld,
host as localhost, database name as mydatabase.

Please advice as to how i can avoid having problems of access denied above.
thank you.
zhen



Jul 19 '05 #3

P: n/a
I have the same problem
I try to improve the security on the mysql and now I can't get into it.
I get this massage.

“Access denied for user: '@localhost' to database 'mysql' ”

Is the same throw webmin or phpMyAdmin

Can anybody please help

I’m runnin Redhat 7.3 and mysql 3.23.56
/harly

c_chen wrote:
Hi, i am a beginner in PHP and mySQL.
Whenever I try to connect my php and mysql
database, i get this error.:
MySQL error : access denied for myuser@localhost (Using password:yes)

I have created a database called mydatabase at the SQLmonitor,
mySQL> create database mydatabase;

then i try to grant the access to mydatabase by
mySQL>GRANT usage on mydatabase.* to myuser@localhost;
mySQL>GRANT ALL PRIVILEGES on mydatabase.* to myuser@localhost;
mySQL>exit
mySQL>SET PASSWORD FOR myuser = Password('helloworld');
I modified the php file with the database username as myuser, password as
helloworld,
host as localhost, database name as mydatabase.

Please advice as to how i can avoid having problems of access denied above.
thank you.
zhen



Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.