Error 1044 Access denied to database

[ruturajv]

the sql file you mentioned...
must not be having "create database thetours..."
and actually directly trying to acces the db..

[haggis]

I am using the same book and am encountering the same error. I am not have much luck finding an answer. I have searched exhaustively through the mysql manual without success.

I think it is a permissions problem.

Have you found a solution yet?

Michelle

[ruturajv]

try this

Code: Select all

mysql -u username DATBASE -p < script.sql


it will prompt you for password.

[WiZARD]

Error 1044 Access denied for user: '@localhost' to database
'newland_tours'

Error 1046 No Database Selected

As I understand, to you need select database before run query. So to you need use mysql_select_db.
Good Luck!

[haggis]

Thanks for your help.

I managed to find another solution. I downloaded MySQL Administrator and created a user account, then downloaded MySQL Control Center created the database and set the permissions.