Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

Error 1044 Access denied to database

Installation and configuration iussues

Moderators: macek, egami, gesf

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..
User avatar
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India

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

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
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India

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!
User avatar
WiZARD
Moderator
Moderator
 
Posts: 1257
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol

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


Return to MySQL Installation

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.