Re: ERROR 1044 (42000): Access denied for user 'root'

[Gleb Paharenko]

Hello.



What says:

 show grants for current_user();





[EMAIL PROTECTED] wrote:

> Hi, 

> 

> As the root user I created a DB a populated with tables... but when I want 

> to create a user to handle that DB i get this error message: 

> 

> mysql> grant all on db.* to [EMAIL PROTECTED] identified by 'password';

> ERROR 1044 (42000): Access denied for user 'root' 

> 

> What could be the reason???

> I though the mysql root user was analogous to the unix counterpart 

> 

> Thanks a lot in advance for your help. 

> 

> Regards,

> Ed

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ERROR 1044 (42000): Access denied for user 'root'

[Dave Juntgen]

Ed,

It sounds like root doesn't have the GRANT permission for the localhost.

You can check by querying the User table in mysql.

--Dave

David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax  : 260.459.6271

> -Original Message-
> From: Guru Vai Kernel-Hacker!!! [mailto:[EMAIL PROTECTED] On
Behalf Of
> [EMAIL PROTECTED]
> Sent: Wednesday, December 15, 2004 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: ERROR 1044 (42000): Access denied for user 'root'
> 
> Hi,
> 
> As the root user I created a DB a populated with tables... but when I
want
> to create a user to handle that DB i get this error message:
> 
> mysql> grant all on db.* to [EMAIL PROTECTED] identified by 'password';
> ERROR 1044 (42000): Access denied for user 'root'
> 
> What could be the reason???
> I though the mysql root user was analogous to the unix counterpart
> 
> Thanks a lot in advance for your help.
> 
> Regards,
> Ed
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'

[gerald_clark]

c s wrote:
Dear friends,
I have a question about mysql.
I installed mysql on windows 2000, after I started the mysql, I tried to create a 
database, but I was denied, I got message:
mysql> show databases;
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.00 sec)
mysql> CREATE DATABASE menagerie;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'
You did not start mysql as root.
mysql -u root

I have read the documentation again and again, it show I can create a host file, but 
ite does not say what kind file it is and where I should put it.   How can I fix it?
Read the section of the manual on permissions.

Thank you for your help
Luke Sui
		
-
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044

[Michael Stassen]

mysqladmin isn't interactive -- it expects a command to process.  With 
no command, mysqladmin prints a help message then quits.  It doesn't 
need a password for that.

For example, to tell the mysql server to shut down, you enter

  mysqladmin -u root -p shutdown

You should be prompted for the password, then mysqld will exit.

See  for more.

Michael

Ralph McCarthy wrote:

Michael:

You were correct. My problem was that I had set a password for mysql but 
didn't realize that I had successfully done so (newbie confusion). I can 
now create a database. Unfortunately, there is an additional issue: it 
appears as though I didn't set a password for mysqladmin (or I did so 
inadvertently and am unaware of what that password is) because when I 
type the following at the prompt:

mysqladmin -u root -p

MySQLAdmin seems to start up without asking for my password:

/usr/local/mysql/bin/mysqladmin  Ver 8.40 Distrib 4.0.17, for 
apple-darwin6.8 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
...

 Shouldn't it request my password? Perhaps this just means that I did 
set the password for both mysql and mysqladmin after installation. What 
should I do?

Thanks for your help.

Ralph

On Wednesday, January 7, 2004, at 01:24 PM, Michael Stassen wrote:

Ralph McCarthy wrote:

Hi:
I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a 
database. When I try to do so, I get the following error message:


I have the same setup.

mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database 
'mydatabase'


See #3 below.

I suspect that the problem may be that I never set the password for 
mysqladmin correctly (perhaps I didn't set it at all).
When I attempt to set it using this command:
mysqladmin -u root -h localhost password 
I get this message:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'


See #1 below.

Please help. Thanks in advance.
Ralph


1) The command

  mysqladmin -u root -h localhost password 

fails because [EMAIL PROTECTED] already has a password which you didn't 
supply.  I expect this is because you've already run

  mysqladmin -u root password 

to set the password.  Once [EMAIL PROTECTED] has a password, you need to 
run mysqladmin like this:

  mysqladmin -u root -p 

The -p indicates you need to suppply the password, so you'll be 
prompted for it.

2) If you don't know what you set as the password for [EMAIL PROTECTED], 
see .

3) The error message indicates you are logged in as the anonymous user 
(username = '') who has no rights (except to the test db).  You 
probably tried just `mysql`.  Instead, you should use

  mysql -u root -p

to indicate you wish to log in as [EMAIL PROTECTED] and be prompted for 
the password.  Once logged in, you might want to get rid of the 
anonymous user, and set yourself up as a normal user.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error 1044

[Jay Blanchard]

[snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html
[/snip]

Sorry, I pulled the send trigger too fast. My bad. 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044

[Douglas Sims]

Both mysql and mysqladmin get user info for login purposes from the same 
place: the mysql.user table.

Mysql doesn't have a root password set by default after installation.  
It's very easy to overlook this and not set a password.  One might think 
that the user you're logging into mysql with will be the same as the 
unix account you're logged in through, but that is only the default and 
you can, of course, override that by specifing -u.  So people often 
forget to set a root password, thinking you have to be logged into unix 
as root in order to log in to mysql as root, but you don't.  I think 
this is a source of some confusion in general.  I've made that mistake :-(

When you set the password, did you do it by using GRANT... or by 
UPDATING the user table directly?  GRANT will automatically flush 
privileges, but altering the user table directly doesn't... which is 
fine, you just have to say FLUSH PRIVILEGES for the changes to take effect.

So you could say
UPDATE mysql.user SET password=password('mysekretpassword') WHERE 
user='root';
FLUSH PRIVILIGES;

And that should do it.

Good luck!

Ralph McCarthy wrote:

Michael:

You were correct. My problem was that I had set a password for mysql 
but didn't realize that I had successfully done so (newbie confusion). 
I can now create a database. Unfortunately, there is an additional 
issue: it appears as though I didn't set a password for mysqladmin (or 
I did so inadvertently and am unaware of what that password is) 
because when I type the following at the prompt:

mysqladmin -u root -p

MySQLAdmin seems to start up without asking for my password:

/usr/local/mysql/bin/mysqladmin  Ver 8.40 Distrib 4.0.17, for 
apple-darwin6.8 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
...

 Shouldn't it request my password? Perhaps this just means that I did 
set the password for both mysql and mysqladmin after installation. 
What should I do?

Thanks for your help.

Ralph

On Wednesday, January 7, 2004, at 01:24 PM, Michael Stassen wrote:

Ralph McCarthy wrote:

Hi:
I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a 
database. When I try to do so, I get the following error message:


I have the same setup.

mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database 
'mydatabase'


See #3 below.

I suspect that the problem may be that I never set the password for 
mysqladmin correctly (perhaps I didn't set it at all).
When I attempt to set it using this command:
mysqladmin -u root -h localhost password 
I get this message:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' 
failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'


See #1 below.

Please help. Thanks in advance.
Ralph


1) The command

  mysqladmin -u root -h localhost password 

fails because [EMAIL PROTECTED] already has a password which you didn't 
supply.  I expect this is because you've already run

  mysqladmin -u root password 

to set the password.  Once [EMAIL PROTECTED] has a password, you need to 
run mysqladmin like this:

  mysqladmin -u root -p 

The -p indicates you need to suppply the password, so you'll be 
prompted for it.

2) If you don't know what you set as the password for [EMAIL PROTECTED], 
see .

3) The error message indicates you are logged in as the anonymous 
user (username = '') who has no rights (except to the test db).  You 
probably tried just `mysql`.  Instead, you should use

  mysql -u root -p

to indicate you wish to log in as [EMAIL PROTECTED] and be prompted for 
the password.  Once logged in, you might want to get rid of the 
anonymous user, and set yourself up as a normal user.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044

[Ralph McCarthy]

Michael:

You were correct. My problem was that I had set a password for mysql 
but didn't realize that I had successfully done so (newbie confusion). 
I can now create a database. Unfortunately, there is an additional 
issue: it appears as though I didn't set a password for mysqladmin (or 
I did so inadvertently and am unaware of what that password is) because 
when I type the following at the prompt:

mysqladmin -u root -p

MySQLAdmin seems to start up without asking for my password:

/usr/local/mysql/bin/mysqladmin  Ver 8.40 Distrib 4.0.17, for 
apple-darwin6.8 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
...

 Shouldn't it request my password? Perhaps this just means that I did 
set the password for both mysql and mysqladmin after installation. What 
should I do?

Thanks for your help.

Ralph

On Wednesday, January 7, 2004, at 01:24 PM, Michael Stassen wrote:

Ralph McCarthy wrote:

Hi:
I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a 
database. When I try to do so, I get the following error message:
I have the same setup.

mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database 
'mydatabase'
See #3 below.

I suspect that the problem may be that I never set the password for 
mysqladmin correctly (perhaps I didn't set it at all).
When I attempt to set it using this command:
mysqladmin -u root -h localhost password 
I get this message:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' 
failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
See #1 below.

Please help. Thanks in advance.
Ralph
1) The command

  mysqladmin -u root -h localhost password 

fails because [EMAIL PROTECTED] already has a password which you didn't 
supply.  I expect this is because you've already run

  mysqladmin -u root password 

to set the password.  Once [EMAIL PROTECTED] has a password, you need to 
run mysqladmin like this:

  mysqladmin -u root -p 

The -p indicates you need to suppply the password, so you'll be 
prompted for it.

2) If you don't know what you set as the password for [EMAIL PROTECTED], 
see .

3) The error message indicates you are logged in as the anonymous user 
(username = '') who has no rights (except to the test db).  You 
probably tried just `mysql`.  Instead, you should use

  mysql -u root -p

to indicate you wish to log in as [EMAIL PROTECTED] and be prompted for 
the password.  Once logged in, you might want to get rid of the 
anonymous user, and set yourself up as a normal user.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044

[Michael Stassen]

Jay Blanchard wrote:

[snip]
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Please help. Thanks in advance.
[/snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html

That's an excellent page to read, but it won't do him much good until he 
can get logged in as [EMAIL PROTECTED]

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044

[Michael Stassen]

Ralph McCarthy wrote:

Hi:

I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a 
database. When I try to do so, I get the following error message:
I have the same setup.

mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database 'mydatabase'
See #3 below.

I suspect that the problem may be that I never set the password for 
mysqladmin correctly (perhaps I didn't set it at all).

When I attempt to set it using this command:

mysqladmin -u root -h localhost password 

I get this message:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
See #1 below.

Please help. Thanks in advance.

Ralph
1) The command

  mysqladmin -u root -h localhost password 

fails because [EMAIL PROTECTED] already has a password which you didn't 
supply.  I expect this is because you've already run

  mysqladmin -u root password 

to set the password.  Once [EMAIL PROTECTED] has a password, you need to 
run mysqladmin like this:

  mysqladmin -u root -p 

The -p indicates you need to suppply the password, so you'll be prompted 
for it.

2) If you don't know what you set as the password for [EMAIL PROTECTED], 
see .

3) The error message indicates you are logged in as the anonymous user 
(username = '') who has no rights (except to the test db).  You probably 
tried just `mysql`.  Instead, you should use

  mysql -u root -p

to indicate you wish to log in as [EMAIL PROTECTED] and be prompted for the 
password.  Once logged in, you might want to get rid of the anonymous 
user, and set yourself up as a normal user.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error 1044

[Jay Blanchard]

[snip]
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'

Please help. Thanks in advance.
[/snip]

Please RTFM at http://www.mysql.com/doc/en/GRANT.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044

[Egor Egorov]

[EMAIL PROTECTED] wrote:
> I recently downloaded MySQL v3.23 on my Windows 2000 laptop.  When I try to
> create a database at the mysql> prompt, I get the message "Error 1044:
> Access denied for user '@localhost' to database xx."  I originally
> assigned a username and password when I first ran the WinMySQL admin 1.4
> tool.  I tried changing this as well, but still no luck.  Please help.

This error means that you connect as anonymous user. Use -u option of mysql to connect 
as a root user and create new users:
shell> mysql -uroot

Here you can find info how to change password, add new user, set up privileges:
http://www.mysql.com/doc/en/Default_privileges.html
http://www.mysql.com/doc/en/Passwords.html
http://www.mysql.com/doc/en/Adding_users.html
http://www.mysql.com/doc/en/GRANT.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error 1044 on database restore

[Victoria Reznichenko]

"Carl B. Constantine" <[EMAIL PROTECTED]> wrote:
> * Victoria Reznichenko ([EMAIL PROTECTED]) wrote:
>> It means that user doesn't have ALTER privilege.
> 
> BUT, I've tried granting the user all privs in mysqlcc and it still
> doesn't work. Looking at my other setup, the users look like they are
> set up the same.
> 

What version do you use? Did you try to do it with mysql client program?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error 1044 on database restore

[Carl B. Constantine]

* Victoria Reznichenko ([EMAIL PROTECTED]) wrote:
> It means that user doesn't have ALTER privilege.

BUT, I've tried granting the user all privs in mysqlcc and it still
doesn't work. Looking at my other setup, the users look like they are
set up the same.

-- 
 .''`.  Carl B. Constantine
: :' : [EMAIL PROTECTED]
`. `'GnuPG: 135F FC30 7A02 B0EB 61DB  34E3 3AF1 DC6C 9F7A 3FF8
  `-  Debian GNU/Linux -- The power of freedom
  "Claiming that your operating system is the best in the world because more
  people use it is like saying McDonalds makes the best food in the world."

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: error 1044 on database restore

[Victoria Reznichenko]

"Carl B. Constantine" <[EMAIL PROTECTED]> wrote:
> I'm trying to move a database from one machine to another. I dumped the
> database and successfully loaded it on one machine, but I can't do it on
> another machine.
> 
> I have the database set up. I created the user to access the database,
> and gave all privs with grant option for that database. But when I go to
> run the command to restore the database, I get the following error:
> 
> $ mysql -u user -p database < database.sql
> Enter password:
> ERROR 1044 at line 26: Access denied for user: '[EMAIL PROTECTED]' to
> database 'database'
> 
> I don't understand. Looking at the sql file, the line is:
> 
> /*!4 ALTER TABLE accidents DISABLE KEYS */;
> LOCK TABLES accidents WRITE;
> UNLOCK TABLES;
> /*!4 ALTER TABLE accidents ENABLE KEYS */;
> 
> Why can I do this on one machine but get an error on the other? The
> users are set up the same. Actually, using mysqlcc, I can't even get the
> user to have the lock tables priv, even though I'm root granting the
> priv, it just refuses to take. Yet, the machine it worked on seems to be
> set up the same way and I didn't have a problem.
> 
> Can someone point me in the right direction to a solution?
> 

It means that user doesn't have ALTER privilege.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Here's the last couple of items from the error log.:

Number of processes running now: 0
030707 21:03:37  mysqld restarted
030707 21:03:37  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
030707 21:03:37  InnoDB: Flushing modified pages from the buffer pool...
030707 21:03:37  InnoDB: Started
/usr/libexec/mysqld: ready for connections.
Version: '4.0.13-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3308
030709 17:56:04  mysqld started
Warning: Ignoring user change to 'root' because the user was set to 
'root' earlier on the command line
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections
A mysqld process already exists at  Wed Jul 9 20:13:04 CDT 2003
A mysqld process already exists at  Wed Jul 9 20:13:14 CDT 2003
A mysqld process already exists at  Wed Jul 9 20:15:42 CDT 2003
A mysqld process already exists at  Wed Jul 9 20:15:50 CDT 2003
030709 20:39:49  /usr/libexec/mysqld: Normal shutdown

030709 20:39:49  /usr/libexec/mysqld: Shutdown Complete

030709 20:39:49  mysqld ended

030709 21:03:48  mysqld started
Warning: Ignoring user change to 'mysql' because the user was set to 
'mysql' earlier on the command line
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections
A mysqld process already exists at  Wed Jul 9 21:19:21 CDT 2003

Nils Valentin wrote:
Hi Kevin,

In this case the error log file (hostname.err) in f.e /var/lib/mysql should 
give you an idea whats going on.

Perhaps the settings inside the my.cnf from the newer version are very 
different then from the older version.

Best regards

Nils Valentin
Tokyo/Japan 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

Hi Kevin,

In this case the error log file (hostname.err) in f.e /var/lib/mysql should 
give you an idea whats going on.

Perhaps the settings inside the my.cnf from the newer version are very 
different then from the older version.

Best regards

Nils Valentin
Tokyo/Japan 




2003年 7月 10日 木曜日 11:23、Kevin H. Phillips さんは書きました:
> This is probably a dead horse but let me post a followup to let everyone
> know what I did and what has happened since.  Maybe I should list it
> under some other error number.
>
> Before Paul posted his message I uninstalled (using rpm -e) version
> 4.0.13.  I then got the RedHat installation CDs and reinstalled the
> version that came boxed with it and then got the update which makes it
> 3.23.56-1.9, I believe.
>
> The server would start fine.  I copied the my.cnf file to /etc and added
> a user mysql to the mysqld section.
>
> Using mysqladmin, I can find version and status but cannot set the
> password for the root user and can't get processlist.  When I try
> setting the password, I get this:
>
> [EMAIL PROTECTED] root]# mysqladmin -u root -p password 'password'
> Enter password:
> mysqladmin: unable to change password; error: 'Access denied for user:
> '@localhost' to database 'mysql''
>
>
> I can't use FLUSH PRIVILEGES either:
>
> [EMAIL PROTECTED] root]# mysql -u root
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 5 to server version: 3.23.56-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> FLUSH PRIVILEGES;
> ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
>
>
> I can't grant privileges:
>
> [EMAIL PROTECTED] root]# mysql -u root
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 6 to server version: 3.23.56-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH
> GRANT OPTION;
> ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
> mysql>
>
> I notice that when the small my.cnf file that is in place when the
> packages first install (just 193K, I think) is used the server will stop
> and start just fine.  When I replace that with a larger version
> (/usr/share/doc/mysql-server-3.23.56 on my installation) then the server
> will not stay running; will show "Failed" when I try to restart.
>
> Kevin Phillips

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

This is probably a dead horse but let me post a followup to let everyone 
know what I did and what has happened since.  Maybe I should list it 
under some other error number.

Before Paul posted his message I uninstalled (using rpm -e) version 
4.0.13.  I then got the RedHat installation CDs and reinstalled the 
version that came boxed with it and then got the update which makes it 
3.23.56-1.9, I believe.

The server would start fine.  I copied the my.cnf file to /etc and added 
a user mysql to the mysqld section.

Using mysqladmin, I can find version and status but cannot set the 
password for the root user and can't get processlist.  When I try 
setting the password, I get this:

[EMAIL PROTECTED] root]# mysqladmin -u root -p password 'password'
Enter password:
mysqladmin: unable to change password; error: 'Access denied for user: 
'@localhost' to database 'mysql''

I can't use FLUSH PRIVILEGES either:

[EMAIL PROTECTED] root]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.56-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> FLUSH PRIVILEGES;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
I can't grant privileges:

[EMAIL PROTECTED] root]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 3.23.56-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH 
GRANT OPTION;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
mysql>

I notice that when the small my.cnf file that is in place when the 
packages first install (just 193K, I think) is used the server will stop 
and start just fine.  When I replace that with a larger version 
(/usr/share/doc/mysql-server-3.23.56 on my installation) then the server 
will not stay running; will show "Failed" when I try to restart.

Kevin Phillips

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

Hi Paul,

A good lesson to learn ;-). 
What you are saying actually means that Kevin didnt need to install it again.
I must have missed this part in the manual.
Thank you for pointing this out.

Best regards

Nils Valentin
Tokyo/Japan

2003年 7月 9日 水曜日 11:14、Paul DuBois さんは書きました:
> At 10:35 +0900 7/7/03, Nils Valentin wrote:
> >2003îN 7åé 7ì™ åéójì™ 10:28ÅANils Valentin 
> >Ç„ÇÒÇÕèëÇ´ÇÐǵLJ:
> >>  Hi Kevin,
> >>
> >>  try this:
> >>
> >>  1) stop the mysql server
> >>  2) mysqld_safe --skip-grant-tables
> >>  3) mysql -u root
> >>  4) mysql> SHOW GRANTS FOR root;
> >>  5) GRANT ALL ON *.* TO 'root'@'%';
> >
> >  GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;
> >
> >
> >sorry for the mistake.
>
> Actually, the mistake is a different one:
>
> When you start the server with --skip-grant-tables, it doesn't read
> the grant tables *at all*.  That means the GRANT and REVOKE statements
> are disabled.  (That's the reason for the "unknown command" error
> reported in other messages in this thread.)
>
> However, once you connect to the server, you can issue FLUSH PRIVILEGES
> to force the server to r-eread the grant tables into memory.  That also
> has the effect of re-enabling GRANT and REVOKE.  (This is why Victoria
> said that FLUSH PRIVILEGES should be used before the GRANT statement.)
>
> >Best regards
> >
> >Nils Valentin
> >Tokyo/Japan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Paul DuBois]

At 10:35 +0900 7/7/03, Nils Valentin wrote:
2003îN 7åé 7ì™ åéójì™ 10:28ÅANils Valentin DŽÇÒÇÕèëÇ´ÇÐǵLJ:
 Hi Kevin,

 try this:

 1) stop the mysql server
 2) mysqld_safe --skip-grant-tables
 3) mysql -u root
 4) mysql> SHOW GRANTS FOR root;
 5) GRANT ALL ON *.* TO 'root'@'%';
 GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;

sorry for the mistake.
Actually, the mistake is a different one:

When you start the server with --skip-grant-tables, it doesn't read
the grant tables *at all*.  That means the GRANT and REVOKE statements
are disabled.  (That's the reason for the "unknown command" error
reported in other messages in this thread.)
However, once you connect to the server, you can issue FLUSH PRIVILEGES
to force the server to r-eread the grant tables into memory.  That also
has the effect of re-enabling GRANT and REVOKE.  (This is why Victoria
said that FLUSH PRIVILEGES should be used before the GRANT statement.)
Best regards

Nils Valentin
Tokyo/Japan


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Victoria Reznichenko]

"Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> Hi, Nils
> I was able to stop the mysqld daemon using the kill command.  However, 
> when I tried to start it using mysqld_safe --skip-grant-tables, a line 
> would appear saying:
> [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
> Starting mysqld daemon with databases from /var/lib/mysql
> 
> with the cursor blinking at the left-hand side of the screen with 
> apparently nothing going on.  The daemon apparently *is* started because 
> I can ping it and get an "alive" signal.
> 
> However, when I try granting options to root, I get an Error 1047: 
> unknown command.  (in the screen where I start the server, while the 
> cursor is blinking, there will be no command line prompt so I have to 
> open another terminal screen.  If I type anything where the cursor is 
> blinking in the first screen, nothing happens).
> 

Execute FLUSH PRIVILEGES before using GRANT command.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

2003年 7月 8日 火曜日 11:40、Kevin H. Phillips さんは書きました:
> Hi, Nils
> I just thought that it would be better, more particularized, for my
> system.  Would it be better to use the precompiled rpms?

Generally talking I believe you can avoid some trouble by using the provided 
rpm binary packages. However, I guess that for some reason ...performance 
tuning, some exotic settings etc. you want to experience to compile it 
yourself, which is probably a good experience, just do it the correct way ;-)

I am unsure were it went wrong so I cant give any advice on how to compile it.

Perhaps somebody on the list can give some advice on how to gracefully compile 
a mysql version ?

Best regards

Nils Valentin
Tokyo/Japan

>
> Thanks,
> Kevin
>
> Nils Valentin wrote:
> > Is there a reason why you dont use the precompiled rpm
> >versions ?
> >
> >Best regards
> >
> >Nils Valentin
> >Tokyo/Japan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Forgot to mention that I installed from an rpm.  I rebuilt a source rpm.

Kevin



Nils Valentin wrote:
 How did you install the mysql server (rpm or tar.gz ) ?
Best regards

Nils Valentin
Tokyo/Japan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Hi, Nils
Here's what I get:
mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password' 
WITH GRANT OPTION;
ERROR 1047: Unknown command
mysql>

I'm sorry I should have asked before if the apostrophes were necessary. 
 And, the first one is an apostrophe and not the little tilted 
apostrophe (not sure of the exact term for it).

Thanks,
Kevin
Nils Valentin wrote:
Try this:

mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password' WITH
 GRANT OPTION;
Note the ' before and after [EMAIL PROTECTED]

However it is a bit unusual that you dont get an error 1064  - wrong sql 
syntax. How did you install the mysql server (rpm or tar.gz ) ?

Best regards

Nils Valentin
Tokyo/Japan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

2003年 7月 8日 火曜日 10:25、Kevin H. Phillips さんは書きました:
> Hi, Nils
> OK, here's a copy of the terminal screen I am getting after killing the
> mysqld daemon and then re-starting it:
>
> [EMAIL PROTECTED] root]# ps ax |grep mysqld
> 32309 pts/0S  0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
> 32334 pts/0S  0:00 /usr/libexec/mysqld --basedir=/usr
> --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/lib/mysql/mail.9-5usa.org.pid --skip-locking
> --skip-grant-tables
> 32383 pts/1S  0:00 grep mysqld
> [EMAIL PROTECTED] root]# mysql -u root
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 4.0.13-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
Server has started up and is running. (which is fine)


> mysql> SHOW GRANTS FOR root;
> ERROR 1047: Unknown command
> mysql> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH
> GRANT OPTION;
> ERROR 1047: Unknown command
> mysql>

Try this:

mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'password' WITH
 GRANT OPTION;

Note the ' before and after [EMAIL PROTECTED]

However it is a bit unusual that you dont get an error 1064  - wrong sql 
syntax. How did you install the mysql server (rpm or tar.gz ) ?

Best regards

Nils Valentin
Tokyo/Japan

>
> Here's the screen I'm getting when I start the daemon:
>
> [EMAIL PROTECTED] root]# ps ax |grep mysqld
> 32308 pts/0S  0:00 grep mysqld
> [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables &
> [1] 32309
> [EMAIL PROTECTED] root]# Starting mysqld daemon with databases from /var/lib/mysql
>
> I hope this information helps.
>
> Thanks very much,
> Kevin
>
> Nils Valentin wrote:
> > Hi Kevin;
> >
> >
> > Try to start it as
> >
> > mysqld_safe --skip-grant-tables &
> >
> > to start the service in the background, you will then be able to continue
> > in the same window. Sorry I didn't mention this.
> >
> > Can you post the grant command you try exactly as it is to the mailing
> > list please (without password of course ;-)
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Hi, Nils
OK, here's a copy of the terminal screen I am getting after killing the 
mysqld daemon and then re-starting it:

[EMAIL PROTECTED] root]# ps ax |grep mysqld
32309 pts/0S  0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables
32334 pts/0S  0:00 /usr/libexec/mysqld --basedir=/usr 
--datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/mail.9-5usa.org.pid --skip-locking 
--skip-grant-tables
32383 pts/1S  0:00 grep mysqld
[EMAIL PROTECTED] root]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.13-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW GRANTS FOR root;
ERROR 1047: Unknown command
mysql> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' WITH 
GRANT OPTION;
ERROR 1047: Unknown command
mysql>

Here's the screen I'm getting when I start the daemon:

[EMAIL PROTECTED] root]# ps ax |grep mysqld
32308 pts/0S  0:00 grep mysqld
[EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables &
[1] 32309
[EMAIL PROTECTED] root]# Starting mysqld daemon with databases from /var/lib/mysql
I hope this information helps.

Thanks very much,
Kevin
Nils Valentin wrote:
Hi Kevin;

Try to start it as 

mysqld_safe --skip-grant-tables &

to start the service in the background, you will then be able to continue in 
the same window. Sorry I didn't mention this.

Can you post the grant command you try exactly as it is to the mailing list 
please (without password of course ;-)

Best regards

Nils Valentin
Tokyo/Japan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

Hi Kevin;


Try to start it as 

mysqld_safe --skip-grant-tables &

to start the service in the background, you will then be able to continue in 
the same window. Sorry I didn't mention this.

Can you post the grant command you try exactly as it is to the mailing list 
please (without password of course ;-)

Best regards

Nils Valentin
Tokyo/Japan

2003年 7月 8日 火曜日 09:51、Kevin H. Phillips さんは書きました:
> Hi, Nils
> I was able to stop the mysqld daemon using the kill command.  However,
> when I tried to start it using mysqld_safe --skip-grant-tables, a line
> would appear saying:
> [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
> Starting mysqld daemon with databases from /var/lib/mysql
>
> with the cursor blinking at the left-hand side of the screen with
> apparently nothing going on.  The daemon apparently *is* started because
> I can ping it and get an "alive" signal.
>
> However, when I try granting options to root, I get an Error 1047:
> unknown command.  (in the screen where I start the server, while the
> cursor is blinking, there will be no command line prompt so I have to
> open another terminal screen.  If I type anything where the cursor is
> blinking in the first screen, nothing happens).
>
> Best,
> Kevin
>
> Nils Valentin wrote:
> > 1) ps ax |grep mysqld
> >
> > to display the process ID. You will get something like
> >
> >  704 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe
> > --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid
> >   756 ?S  0:01 /usr/sbin/mysqld-max --basedir=/
> > --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid
> > --skip-locking
> >   923 ?S  0:00 /usr/sbin/mysqld-max --basedir=/
> > --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid
> > --skip-locking
> >
> > 2) kill -9  >
> > That WILL stop the mysqld demon. In case you see several processes (which
> > is more likely), just start wit the first processid shown.
> >
> > 3) Check again with "ps ax |grep mysqld" that ALL processes stopped.
> > 4) proceed as described in my previous e-mail.
> > 5) After having setup the rights for the "root" user. you should make
> > sure that all database files are intact (myisamchk etc)
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Hi, Nils
I was able to stop the mysqld daemon using the kill command.  However, 
when I tried to start it using mysqld_safe --skip-grant-tables, a line 
would appear saying:
[EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
Starting mysqld daemon with databases from /var/lib/mysql

with the cursor blinking at the left-hand side of the screen with 
apparently nothing going on.  The daemon apparently *is* started because 
I can ping it and get an "alive" signal.

However, when I try granting options to root, I get an Error 1047: 
unknown command.  (in the screen where I start the server, while the 
cursor is blinking, there will be no command line prompt so I have to 
open another terminal screen.  If I type anything where the cursor is 
blinking in the first screen, nothing happens).

Best,
Kevin


Nils Valentin wrote:
1) ps ax |grep mysqld

to display the process ID. You will get something like

 704 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe 
--datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid
  756 ?S  0:01 /usr/sbin/mysqld-max --basedir=/ 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid 
--skip-locking
  923 ?S  0:00 /usr/sbin/mysqld-max --basedir=/ 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid 
--skip-locking

2) kill -9 

That WILL stop the mysqld demon. In case you see several processes (which is 
more likely), just start wit the first processid shown.

3) Check again with "ps ax |grep mysqld" that ALL processes stopped.
4) proceed as described in my previous e-mail.
5) After having setup the rights for the "root" user. you should make sure 
that all database files are intact (myisamchk etc)

Best regards

Nils Valentin
Tokyo/Japan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

Hi Kevin,

There is a way to sop the server on OS level. However I am not sure if you 
want to do it this way. You can use the kill command, but be aware that it 
might damage a data file if the database is accessing it in just this moment.

Having said this warning, here is what you can do:

1) ps ax |grep mysqld

to display the process ID. You will get something like

 704 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe 
--datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid
  756 ?S  0:01 /usr/sbin/mysqld-max --basedir=/ 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid 
--skip-locking
  923 ?S  0:00 /usr/sbin/mysqld-max --basedir=/ 
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid 
--skip-locking

2) kill -9  Hi, Nils
> I can't get the mysql server to stop!  If I try "service mysqld stop" I
> get a "FAILED" error.  If I try mysqladmin -u root -p shutdown, I get:
>
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
> [EMAIL PROTECTED] root]#
>
> If I try shutting down without using a password, I get a message saying
> that access is denied; I need shutdown privileges for this operation.
>
> I have pinged the server and it *says* that it is "alive".
>
> Perplexing problem, no?
>
> Kevin
>
> Nils Valentin wrote:
> > 2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました:
> >>Hi Kevin,
> >>
> >>try this:
> >>
> >>1) stop the mysql server
> >>2) mysqld_safe --skip-grant-tables
> >>3) mysql -u root
> >>4) mysql> SHOW GRANTS FOR root;
> >>5) GRANT ALL ON *.* TO 'root'@'%';
> >
> >  GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;
> >
> >
> > sorry for the mistake.
> >
> > Best regards
> >
> > Nils Valentin
> > Tokyo/Japan
> >
> >>6) restart the server (without  --skip-grant-table option) and try to
> >> login
> >>
> >>Best regards
> >>
> >>Nils Valentin
> >>Tokyo/Japan

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Hi, Nils
I can't get the mysql server to stop!  If I try "service mysqld stop" I 
get a "FAILED" error.  If I try mysqladmin -u root -p shutdown, I get:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
[EMAIL PROTECTED] root]#
If I try shutting down without using a password, I get a message saying 
that access is denied; I need shutdown privileges for this operation.

I have pinged the server and it *says* that it is "alive".

Perplexing problem, no?

Kevin

Nils Valentin wrote:
2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました:

Hi Kevin,

try this:

1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';


 GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;

sorry for the mistake.

Best regards

Nils Valentin
Tokyo/Japan

6) restart the server (without  --skip-grant-table option) and try to login

Best regards

Nils Valentin
Tokyo/Japan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました:
> Hi Kevin,
>
> try this:
>
> 1) stop the mysql server
> 2) mysqld_safe --skip-grant-tables
> 3) mysql -u root
> 4) mysql> SHOW GRANTS FOR root;
> 5) GRANT ALL ON *.* TO 'root'@'%';

 GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;


sorry for the mistake.

Best regards

Nils Valentin
Tokyo/Japan

>
> 6) restart the server (without  --skip-grant-table option) and try to login
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 7月 5日 土曜日 00:29、Victoria Reznichenko さんは書きました:
> > "Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> > > I am trying to set up mysql 4.0.13 on my RedHat 9 machine.  I rebuilt
> > > the source rpm. (I had a previous installation which I deleted first).
> > >
> > > I can log on to the mysql monitor as root but can't creat databases,
> > > can't change passwords, can't grant privileges, can't select hosts,
> > > can't seem to do anything.
> > >
> > > I'm getting Errors 1044 & 2003.  Here's some of the output:
> > >
> > > [EMAIL PROTECTED] root]# mysql -u root mysql
> > > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > > Your MySQL connection id is 19 to server version: 4.0.13-log
> > >
> > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > >
> > > mysql> CREATE DATABASE ;
> > > ERROR 1044: Access denied for user: '@localhost' to database
> > > '' mysql> \q
> > > Bye
> > > [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1
> > > ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111)
> > > [EMAIL PROTECTED] root]# mysql -u root mysql
> > > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > > Your MySQL connection id is 20 to server version: 4.0.13-log
> > >
> > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > >
> > > mysql> SHOW GRANTS FOR root;
> > > ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> > > mysql>
> > >
> > > This may have been covered before.  If so, I apologize for the
> > > repition.
> >
> > What is the output of SELECT USER()?
> >
> >
> >
> > --
> > For technical support contracts, goto https://order.mysql.com/?ref=ensita
> > This email is sponsored by Ensita.net http://www.ensita.net/
> >__  ___ ___   __
> >   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
> >  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> > /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
> ><___/   www.mysql.com
>
> --
> ---
> Valentin Nils
> Internet Technology
>
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

Hi Kevin,

try this:

1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';

6) restart the server (without  --skip-grant-table option) and try to login

Best regards

Nils Valentin
Tokyo/Japan


2003年 7月 5日 土曜日 00:29、Victoria Reznichenko さんは書きました:
> "Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> > I am trying to set up mysql 4.0.13 on my RedHat 9 machine.  I rebuilt
> > the source rpm. (I had a previous installation which I deleted first).
> >
> > I can log on to the mysql monitor as root but can't creat databases,
> > can't change passwords, can't grant privileges, can't select hosts,
> > can't seem to do anything.
> >
> > I'm getting Errors 1044 & 2003.  Here's some of the output:
> >
> > [EMAIL PROTECTED] root]# mysql -u root mysql
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 19 to server version: 4.0.13-log
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> CREATE DATABASE ;
> > ERROR 1044: Access denied for user: '@localhost' to database
> > '' mysql> \q
> > Bye
> > [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1
> > ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111)
> > [EMAIL PROTECTED] root]# mysql -u root mysql
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 20 to server version: 4.0.13-log
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> SHOW GRANTS FOR root;
> > ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> > mysql>
> >
> > This may have been covered before.  If so, I apologize for the repition.
>
> What is the output of SELECT USER()?
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Here's what I get:

mysql> SELECT USER();
++
| USER() |
++
| [EMAIL PROTECTED] |
++
1 row in set (0.02 sec)
mysql>

Kevin

Victoria Reznichenko wrote:
What is the output of SELECT USER()?





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Victoria Reznichenko]

"Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> I am trying to set up mysql 4.0.13 on my RedHat 9 machine.  I rebuilt 
> the source rpm. (I had a previous installation which I deleted first).
> 
> I can log on to the mysql monitor as root but can't creat databases, 
> can't change passwords, can't grant privileges, can't select hosts, 
> can't seem to do anything.
> 
> I'm getting Errors 1044 & 2003.  Here's some of the output:
> 
> [EMAIL PROTECTED] root]# mysql -u root mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 19 to server version: 4.0.13-log
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> CREATE DATABASE ;
> ERROR 1044: Access denied for user: '@localhost' to database ''
> mysql> \q
> Bye
> [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1
> ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111)
> [EMAIL PROTECTED] root]# mysql -u root mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 20 to server version: 4.0.13-log
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> SHOW GRANTS FOR root;
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> mysql>
> 
> This may have been covered before.  If so, I apologize for the repition.

What is the output of SELECT USER()?



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1044

[Egor Egorov]

Ed Kiefer <[EMAIL PROTECTED]> wrote:
> I keep getting this error when I try to create a new database:
> 
> mysql> create database cheese_catalog;
> ERROR 1044: Access denied for user: '@localhost' to database'cheese_catalog'

User doesn't have permissions to create database.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1044: Access denied for user

[Alexander Barkov]

It means you don't have enough privileges to access
'mysql' database. You can add these privileges using
"GRANT" command under user 'root' (or under another
superuser). Check manual, the section about privileges.


anjani.sinha wrote:
> Hi all,
> 
> I am getting the error when trying to connect server from my client:
> 
> ERROR 1044: Access denied for user: '@NRICRIV1.ad.rivenet.com' to database
> 'mysql'
> 
> any answer?
> 
> thanks,
> 
> anjani
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 



-- 
For technical support contracts, visit https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Alexander Barkov <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Izhevsk, Russia
<___/   www.mysql.com   +7-902-856-80-21


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 1044: Access denied

[Dana Powers]

The way mysql access tables work, if it cant find a user named 'user2', it
will default to the blank user ( '' ).
dpk

- Original Message -
From: "Pierre-Yves" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 4:39 PM
Subject: Re: ERROR 1044: Access denied


>
> - Original Message -
> From: "Dana Powers" <[EMAIL PROTECTED]>
> To: "Pierre-Yves" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 29, 2001 1:22 AM
> Subject: Re: ERROR 1044: Access denied
>
>
> > > ERROR 1044: Access denied for user: '@localhost' to database 'hello'
> > This says that you are connected as user '' ( blank ) from localhost.
Make
> > sure you're logging on correctly and try again.
> > dpk
>
> but I use the following command to connect mysql :
>
> mysql --user=user2 --host=localhost
>
> (there is no password for this user)
> and when I do this with the user1 it is working...
> so i don't think that's the problem.
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 1044: Access denied

[Pierre-Yves]

- Original Message -
From: "Dana Powers" <[EMAIL PROTECTED]>
To: "Pierre-Yves" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 1:22 AM
Subject: Re: ERROR 1044: Access denied


> > ERROR 1044: Access denied for user: '@localhost' to database 'hello'
> This says that you are connected as user '' ( blank ) from localhost. Make
> sure you're logging on correctly and try again.
> dpk

but I use the following command to connect mysql :

mysql --user=user2 --host=localhost

(there is no password for this user)
and when I do this with the user1 it is working...
so i don't think that's the problem.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 1044: Access denied

[Dana Powers]

> ERROR 1044: Access denied for user: '@localhost' to database 'hello'
This says that you are connected as user '' ( blank ) from localhost. Make
sure you're logging on correctly and try again.
dpk


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 1044

[Matt Wagner]

Franck ABELLI writes:
> To change the root password i connected to mysql: bin/mysql
> mysql>connect mysql localhost
> mysql>UPDATE user set Password='***' where User='root';
> ->No problems
> mysql>SELECT User,Password FROM user;
> -> to verify if the pass was set... it was.
> 
> then i stopped mysql and restart it and it was impossible connecting
> again. here is the detailed result :
> 
> Linux>bin/mysql -u root -p
> Enter password : 
> mysql >use mysql
> Database changed
> mysql>SELECT * FROM user;
> ERROR 1044:Access Denied for user: '@localhost' to database 'mysql'
> ERROR:
> can't connect to the server
> 
> 
> sure,i made mistakes, but now how can i recover my Mysql  ?

Hi!

If you are going to go about setting the password in this fashion,
then you need to make sure to use the password() function in your
UPDATE statement. For example:

  UPDATE user set Password=password('***') where User='root';

To connect to your server in it's current state (with bad root passwd)
you need to start mysqld with the '--skip-grant-tables' option.

In the future, instead of restarting the mysql daemon for changes to
the grant tables to take effect, check out 'FLUSH PRIVILEGES'.

  http://www.mysql.com/manual.php?section=FLUSH


Regards,

   Matt

-- 
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Matt Wagner <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  River Falls, Wisconsin, USA
   <___/   Developer


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 1044

[Rolf Hopkins]

- Original Message -
From: "Franck ABELLI" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 23:29
Subject: ERROR 1044


> i can now connect to mysql but when i login as root with the root
> password i get the ERROR 1044 : Access denied.
> if i don't give any password i can connect but if i write:
> mysql> use mysql
> i've got the same message, so i can't do anything neither connect nor
> create database,tables...
>
> -i made the install described in the doc of mysql (groupadd, useradd...)
>
> ->it worked
>  and when i've changed the root password, i restart mysqld and i've got
> the error since this moment.
>
> i changed the owner/group of the /mysql dir to set it to root/root,
> changed the permisions to 777, but it's still the same.
>

That is not such a good idea.  I suggest changing it back.

What is the exact command you used to change the root password and the exact
command you used to login?

ADVICE:  Replace the password with Xs or something, unless you want the
world to be able to log into your machine and do what they like with your
DB.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php