Error 1044 Access denied to database

Installation and configuration iussues

Moderators: macek, egami, gesf

User avatar
ruturajv
php-forum Super User
php-forum Super User
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India
Contact:

Postby ruturajv » Sun Jun 06, 2004 7:56 pm

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

haggis
New php-forum User
New php-forum User
Posts: 2
Joined: Mon Jun 14, 2004 12:24 pm

same 1044-1046 problem

Postby haggis » Mon Jun 14, 2004 12:37 pm

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

User avatar
ruturajv
php-forum Super User
php-forum Super User
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India
Contact:

Postby ruturajv » Mon Jun 14, 2004 8:22 pm

try this

Code: Select all

mysql -u username DATBASE -p < script.sql


it will prompt you for password.

User avatar
WiZARD
Moderator
Moderator
Posts: 1257
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol
Contact:

Re: Error 1044 Access denied to database

Postby WiZARD » Mon Jun 14, 2004 10:54 pm

john10001 wrote:
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
New php-forum User
New php-forum User
Posts: 2
Joined: Mon Jun 14, 2004 12:24 pm

Thank You

Postby haggis » Wed Jun 16, 2004 9:39 pm

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.


Return to “MySQL Installation”

Who is online

Users browsing this forum: No registered users and 1 guest

cron