Error 1044 Access denied to database

[John]

Hello.

I am currently working through a book on Dreamweaver and using PHP. I
am having a little trouble with setting up the database though. I
have php 4.2.3 and MySQL 4.0.20a. I am running locally with Apache
1.3.27 on Windows XP Pro.

I seem to have finally got MySQL running after a lot of difficulty.
In the book it says to type source C:\mysql\newlan d_tours.sql at the
mysql> prompt, to generate the newland_tours database in my copy of
MySQL.

When I do this however it gives me an error message saying:

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

and numerous other ones saying:

Error 1046 No Database Selected

If you can help me I'd be very grateful. I think that something must
be wrong or amiss with the settings or the paths to the files in
my.ini file? Or perhaps it is just a bug with php or MySql?

Thanks very much for any help

John

[Janwillem Borleffs]

John wrote:

I seem to have finally got MySQL running after a lot of difficulty.
In the book it says to type source C:\mysql\newlan d_tours.sql at the
mysql> prompt, to generate the newland_tours database in my copy of
MySQL.

When I do this however it gives me an error message saying:

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

Make sure that the correct user is defined in mysql and supply it, e.g.:

path\to\mysql-installation\bi n\mysql -uroot -prootpasswd < newland_tours.s ql

For more info on priveleges, see:

http://dev.mysql.com/doc/mysql/en/De...rivileges.html and
http://dev.mysql.com/doc/mysql/en/GRANT.html
JW

[John]

On Sat, 05 Jun 2004 20:59:00 GMT, "Janwillem Borleffs"
<jw@jwscripts.c om> wrote:

John wrote:

I seem to have finally got MySQL running after a lot of difficulty.
In the book it says to type source C:\mysql\newlan d_tours.sql at the
mysql> prompt, to generate the newland_tours database in my copy of
MySQL.

When I do this however it gives me an error message saying:

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

Make sure that the correct user is defined in mysql and supply it, e.g.:

path\to\mysq l-installation\bi n\mysql -uroot -prootpasswd < newland_tours.s ql

How exactly do I define correct user and supply it?

When I go to the mysql> prompt do I type in what you have put?

path\to\mysql-installation\bi n\mysql -uroot -prootpasswd <
newland_tours.s ql

I understand everything here: path\to\mysql-installation\bi n\mysql

but I don't have a clue about this: -uroot -prootpasswd <
For more info on priveleges, see:

http://dev.mysql.com/doc/mysql/en/De...rivileges.html and
http://dev.mysql.com/doc/mysql/en/GRANT.html

I have taken a look at these links and all the different sections and
subsections, but it is far too complex for me. I am just a beginner.
I need it explained simply what to do.

Cheers

John

[kingofkolt]

"John" <ph********@nee dshelp.com> wrote in message
news:gb******** *************** *********@4ax.c om...

On Sat, 05 Jun 2004 20:59:00 GMT, "Janwillem Borleffs"
<jw@jwscripts.c om> wrote:

John wrote:

I seem to have finally got MySQL running after a lot of difficulty.
In the book it says to type source C:\mysql\newlan d_tours.sql at the
mysql> prompt, to generate the newland_tours database in my copy of
MySQL.

When I do this however it gives me an error message saying:

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

Make sure that the correct user is defined in mysql and supply it, e.g.:

path\to\mysq l-installation\bi n\mysql -uroot -prootpasswd <

newland_tours.s ql
How exactly do I define correct user and supply it?

When I go to the mysql> prompt do I type in what you have put?

path\to\mysql-installation\bi n\mysql -uroot -prootpasswd <
newland_tours.s ql

I understand everything here: path\to\mysql-installation\bi n\mysql

but I don't have a clue about this: -uroot -prootpasswd <

For more info on priveleges, see:

http://dev.mysql.com/doc/mysql/en/De...rivileges.html and
http://dev.mysql.com/doc/mysql/en/GRANT.html

I have taken a look at these links and all the different sections and
subsections, but it is far too complex for me. I am just a beginner.
I need it explained simply what to do.

Cheers

John

What Janwillem Borleffs meant was this: Suppose your username for mysql is
"John" and your password is "bafooey", when you're starting up MySQL in the
prompt, type this:

path\to\mysql-installation\bi n\mysql -uJohn -pbafooey

However you may not have created any usernames/passwords for MySQL yet... if
this is the case, type this at the prompt instead:

path\to\mysql-installation\bi n\mysql -uroot -p

This will log you in as the root user (the root user is the user with access
to all databases and all tables within the databases). Once mysql is open
then type this:

\u mysql

^that selects the MySQL database where you can create users. to create a
user type this:

GRANT ALL ON newland_tours.* TO John@localhost IDENTIFIED BY "bafooey";

^^ that command creates the user John with password "bafooey". the
"newland_tours. *" means that the user John has access to all tables in the
newland_tours database (the * means all tables). Once you have created this
user, you can use it to work on the newland_tours database and not have
access problems.

hope this helped

- JP

[John]

What Janwillem Borleffs meant was this: Suppose your username for mysql is
"John" and your password is "bafooey", when you're starting up MySQL in the
prompt, type this:
I think that MySql already starts up automatically when my system is
switched on as I have a traffic lights icon in the system tray which
is on green?
path\to\mysq l-installation\bi n\mysql -uJohn -pbafooey
When I type this with the username and password that were created in
the my.ini file it gives the following:

Outfield Disabled.
ERROR:
Unknown command '\m'.
ERROR:
Unknown command '\b'.
ERROR:
Unknown command '\m'.

However you may not have created any usernames/passwords for MySQL yet... if
this is the case, type this at the prompt instead:

path\to\mysq l-installation\bi n\mysql -uroot -p

If I try this without username and password it gives the same error as
before.

MySql is so frustrating to set up it's unbelievable.

John

[Michael Vilain]

In article <gb************ *************** *****@4ax.com>,
John <ph********@nee dshelp.com> wrote:

On Sat, 05 Jun 2004 20:59:00 GMT, "Janwillem Borleffs"
<jw@jwscripts.c om> wrote:

John wrote:

I seem to have finally got MySQL running after a lot of difficulty.
In the book it says to type source C:\mysql\newlan d_tours.sql at the
mysql> prompt, to generate the newland_tours database in my copy of
MySQL.

When I do this however it gives me an error message saying:

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

Make sure that the correct user is defined in mysql and supply it, e.g.:

path\to\mysq l-installation\bi n\mysql -uroot -prootpasswd < newland_tours.s ql

How exactly do I define correct user and supply it?

When I go to the mysql> prompt do I type in what you have put?

path\to\mysql-installation\bi n\mysql -uroot -prootpasswd <
newland_tours.s ql

I understand everything here: path\to\mysql-installation\bi n\mysql

but I don't have a clue about this: -uroot -prootpasswd <

For more info on priveleges, see:

http://dev.mysql.com/doc/mysql/en/De...rivileges.html and
http://dev.mysql.com/doc/mysql/en/GRANT.html

I have taken a look at these links and all the different sections and
subsections, but it is far too complex for me. I am just a beginner.
I need it explained simply what to do.

Cheers

John

Buy a book on MySQL and read it. It's whole other rathole in addition
to php. You'll need to understand what a real DBMS is doing and how it
does it. It's not trivial. Be ready for your brain to turn to tapioca
and leak out your ears.

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[John]

On Sat, 05 Jun 2004 22:59:01 -0700, "Michael Vilain
<vi****@spamcop .net>" wrote:

Buy a book on MySQL and read it. It's whole other rathole in addition
to php. You'll need to understand what a real DBMS is doing and how it
does it. It's not trivial. Be ready for your brain to turn to tapioca
and leak out your ears.

I already have two books.

John

[Aggro]

John wrote:

If you can help me I'd be very grateful. I think that something must
be wrong or amiss with the settings or the paths to the files in
my.ini file? Or perhaps it is just a bug with php or MySql?

It is not a bug, and it has nothing to do with php, so alt.php,
alt.comp.lang.p hp and comp.lang.php groups are not concerned about this
problem.

And even if this would be problem for php also, don't post to several
different newsgroups. Pick one group and one group only and post your
question to there. If you fail to get help from there, think again was
the group selection good or bad and did you ask the question properly.
If you think yes, then you can try another group. Why you should do
this? Because many people don't usually even bother to answer people who
post the question into many newsgroups, because it is against the
netiquette. This is only a friendly advice, because you might not know
this "rule". Don't be offended by me reminding it.

Now, to your problem.

When you installed MySQL you had a root account at the very beginning.
You might have changed the password for it, but if you havent, the
password is empty. The root user has privileges to do anything in the
database, while test user (which is the user you seem to have logged in,
has privileges only in the "test" database.) Try to start your mysql
console program like this:

mysql -u root

If you can get in, you don't have a root password, but that doesn't
matter with this problem. When you get in, try to type the command you
tried earlier:

source C:\mysql\newlan d_tours.sql

It should not give the same error anymore.

Follow-ups set to mailing.databas e.mysql only

[bill]

On Sat, 05 Jun 2004 21:20:45 +0100, John <ph********@nee dshelp.com>
wrote:

I seem to have finally got MySQL running after a lot of difficulty.
In the book it says to type source C:\mysql\newlan d_tours.sql at the
mysql> prompt, to generate the newland_tours database in my copy of
MySQL.

I remember how confusing rhis can be. Before you start loading
databases, you need to know exactly how to log in at the mysql command
line. It gets confusing right there because you log in a bit
differently depending on whether or not you set up a user & password.

First off, you need to see if you can log in correctly. So, open your
Command Prompt and cd to the mysql/bin directory. On my machine, it's:

C:\> cd c:\mysql\bin

Once you get to the correct directory, try logging in without any
username or password like this:

C:\mysql\bin\> mysql

That will log you in as the root user if you haven't already set up a
password for root. If you have set a password up, then you can log in
with it like this:

C:\mysql\bin> mysql -u root -p

And then mysql will prompt you for the root password. The -u stands
for "user", which in this case is root. To log in as egghead, type:

C:\mysql\bin> mysql -u egghead -p

The -p means: prompt me for a password.

Now you can get your database loaded up. It will be easier for you if
you copy the C:\mysql\newlan d_tours.sql file to the mysql\bin
directory. Once you've done that, cd to the mysql\bin directory as if
you were going to log in, and do this:

C:\mysql\bin\my sql < newland_tours.s ql

Or if you have a password,

C:\mysql\bin\my sql -u root -p < newland_tours.s ql

And enter the password when prompted. If all goes well, you'll get
dumped back to the original prompt with no messages.

If you get errors, and you probably will:

Check that the database already exists. If not, then log in and create
it.

If it says "No database selected", open up the newland_tours.s ql
file in notepad, and on the top line type:

USE DATABASE newland_tours;

or whatever the database name is. That should do it!

[Chris Arthur]

Sounds like theres not telling it what user to use - if you haven't set
on up you should be able to use the root user (root@localhost ) - as an
aside why not just use easyPHP to set up mysql/apache - it take five
minutes??)