Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[Cassj]

Thibaud...

If you have already set your MySQL root password, then you need to login to 
mysql like this:
 mysql -u root -p
You should be prompted for the mysql root password.

If you haven't set your mysql root password, then you need to do this:
 mysqladmin -u root password 'new-password'
You may have to give the complete path to mysqladmin.

CheersCassj



-Original Message-
From: Thibaud Hulin [EMAIL PROTECTED]
Sent: May 9, 2007 4:13 PM
To: mysql@lists.mysql.com
Subject: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
password: NO)

Hi,
I installed mysql 4.1.22 for Debian testing.
I launched the manual installation.
However, when I do :
mysql -u root

I get :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
password: NO)

I tried to reinstall it, but it fails.

Thanks for help,
Thibaud.


-- 
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 1045 (28000): Access denied for user 'root'@'localhost'

[thomas Armstrong]

Fixed:
[]# kill `cat /usr/local/mysql/var/server.pid`
[]# /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
[]# /usr/local/mysql/bin/mysql
mysql update user set password = password('xxx') where user =
'root' and host='localhost';

On 2/20/07, thomas Armstrong [EMAIL PROTECTED] wrote:

Hi.

Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
-
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
--

I created a '/root/root.sql' file:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xx');


And killed the process and restarted:

[EMAIL PROTECTED] ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql 

[1] 2494
[EMAIL PROTECTED] ~]# Starting mysqld daemon with databases from 
/usr/local/mysql/var


But I get the same error message :(

In my '/usr/local/mysql/var/server.err' file there's no error message:
--
070220 07:03:40  mysqld started
070220 07:03:40  InnoDB: Started; log sequence number 0 3758734
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.1.22'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
---

What am I doing wrong?



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

Re: Error 1045 - Access denied

[Dan Buettner]

Miles, can you access the remote database from any other tools on your 
local machine?  mysql command line, etc.


You state you can use phpmyadmin, but is that installed at your hosting 
provider?


It's not unusual for hosting providers to lock down their database hosts 
to only allow access from other hosts on the provider's network.  Added 
security, added control.  My provider, pair Networks, by default locks 
the dbs down to their network only, but I have the option to open them up.


Dan


Miles Thompson wrote:

I have searched the MySQL Administrator forum for help on this, but no joy.

When I try to conect to a database on Dreamhost, using MySQL 
Administrator, I get this error, with a red X in a Windows dialog box:

(The name of the database and and user are changed)
--- 


Could not connect to the specified instance.
MySQL Error Number 1045
Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using
password: YES)

If you want to check the network connection, please click the PING button

[OK] [PING]
-- 



It pings OK, and I can use phpMyAdmin, I just wanted to try a more 
direct tool.
Dreamhost has not been a lot of help. I suspect it's because MySQL 
Administrator is too powerful.


Regards - Miles Thompson




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

Re: Error 1045 - Access denied

[Miles Thompson]

Dan,

I believe Dreamhost has it MySQL locked down so that only they have primary 
access, and yes phpMyAdmin is installed on their system.


It would be .v. difficult for them to give me rights. g

This is sort of off-topic, but hub.org, which operates out of Wolfville, 
NS, has shut down the central MySQL database for all their clients and each 
client now has a private instance running in the virtual host. V. nice.


Thanks for having a look.

Miles




At 12:32 PM 6/16/2006, Dan Buettner wrote:

Miles, can you access the remote database from any other tools on your 
local machine?  mysql command line, etc.


You state you can use phpmyadmin, but is that installed at your hosting 
provider?


It's not unusual for hosting providers to lock down their database hosts 
to only allow access from other hosts on the provider's network.  Added 
security, added control.  My provider, pair Networks, by default locks the 
dbs down to their network only, but I have the option to open them up.


Dan


Miles Thompson wrote:

I have searched the MySQL Administrator forum for help on this, but no joy.
When I try to conect to a database on Dreamhost, using MySQL 
Administrator, I get this error, with a red X in a Windows dialog box:

(The name of the database and and user are changed)
--- 


Could not connect to the specified instance.
MySQL Error Number 1045
Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using
password: YES)
If you want to check the network connection, please click the PING button
[OK] [PING]
-- 

It pings OK, and I can use phpMyAdmin, I just wanted to try a more direct 
tool.
Dreamhost has not been a lot of help. I suspect it's because MySQL 
Administrator is too powerful.

Regards - Miles Thompson


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





--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.0/366 - Release Date: 6/15/2006



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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

[Aron Levy]

Thank you very much James, i flush the privilegies and restart the mysql 
service and all result fine :-)


I can access from anyhost

Aron L.

James Barros wrote:


Can this use log in from localhost successfully?
Try flushing privileges again?
If that failed, I'd drop the user and recreate?
( Theres really not alot to this, sorry I don't have any more ideas :( )

-- James

On Jun 7, 2006, at 1:07 PM, Aron Levy wrote:

Hi James i follow your recomendation and verify that the hash  
produced  matches the password field in user exactly.


-- Aron L.

James Barros wrote:

Well, for starters don't worry about ports being open. If you  
werent  able to connect, it would give you a different error message.


select password('yourpassword'); and verify that the hash  produced  
matches the password field in user exactly.


-- James


On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:

Hi good afternoon, i am triying to connect with my company's  
mysql  server using a client program from shell and I keep  
receiving the  following answer:


[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user   
'user1'@'200.93.42.209' (using password: YES)

[EMAIL PROTECTED] ~]#

I already checked the user was configured for any host (%),  the  
port 3306 is open (checked with nmap), but i dont know what  i 
need  to do or see other variables.  I am 100% sure of the  
passwords i am  using for this users, and i am attaching some  info 
about the database.


Thank you in advance,


mysql select * from user;
+---+--+--+-  
+-+-+-+- 
+--- +-+---+-- 
+--- ++-+ 
++
| Host  | User | Password | Select_priv |   
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv  
|  Reload_priv | Shutdown_priv |Process_priv | File_priv |  
Grant_priv  | References_priv | Index_priv | Alter_priv |
+---+--+--+-  
+-+-+-+- 
+--- +-+---+-- 
+--- ++-+ 
++
| % | user1  | 5804b8eebr456240 | N   |  
N| N   | N   | N   |  N 
| N| N | N|  N | 
N  |  N   | N  |  N  |
| % | user4 | 6f37d73jsdred201d | N   |  
N| N   | N   | N   |  N 
| N| N | N|  N | 
N  |  N   | N  |  N  |


[EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com

Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at  
2006-06-07  09:57 VET

Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATESERVICEVERSION
21/tcp   open ftpProFTPD 1.2.10
22/tcp   open sshOpenSSH 3.9p1 (protocol 1.99)
25/tcp   open smtp   netqmail smtpd 1.04
53/tcp   open domain
80/tcp   open http   Apache httpd 2.0.53 ((Fedora))
106/tcp  open pop3pw poppassd
110/tcp  open pop3   Courier pop3d
111/tcp  open rpcbind 2 (rpc #10)
135/tcp  filtered msrpc
139/tcp  filtered netbios-ssn
143/tcp  open imap   Courier Imapd (released 2004)
443/tcp  open ssl/http   Apache httpd 2.0.53 ((Fedora))
445/tcp  filtered microsoft-ds
465/tcp  open ssl/smtp   netqmail smtpd 1.04
593/tcp  filtered http-rpc-epmap
993/tcp  open ssl/imap   Courier Imapd (released 2004)
995/tcp  open ssl/pop3   Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql  MySQL 4.1.15
/tcp filtered krb524
8443/tcp open http   Apache httpd 1.3.33 ((Unix)   
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)

Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix

Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds

mysql

MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

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









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









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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

[James Barros]

Well, for starters don't worry about ports being open. If you werent  
able to connect, it would give you a different error message.


select password('yourpassword'); and verify that the hash produced  
matches the password field in user exactly.


-- James


On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:

Hi good afternoon, i am triying to connect with my company's mysql  
server using a client program from shell and I keep receiving the  
following answer:


[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user  
'user1'@'200.93.42.209' (using password: YES)

[EMAIL PROTECTED] ~]#

I already checked the user was configured for any host (%), the  
port 3306 is open (checked with nmap), but i dont know what i need  
to do or see other variables.  I am 100% sure of the passwords i am  
using for this users, and i am attaching some info about the database.


Thank you in advance,


mysql select * from user;
+---+--+--+- 
+-+-+-+-+--- 
+-+---+--+--- 
++-+++
| Host  | User | Password | Select_priv |  
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |  
Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv  
| References_priv | Index_priv | Alter_priv |
+---+--+--+- 
+-+-+-+-+--- 
+-+---+--+--- 
++-+++
| % | user1  | 5804b8eebr456240 | N   | N
| N   | N   | N   | N | N
| N | N| N | N  |  
N   | N  | N  |
| % | user4 | 6f37d73jsdred201d | N   | N
| N   | N   | N   | N | N
| N | N| N | N  |  
N   | N  | N  |


[EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com

Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07  
09:57 VET

Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATESERVICEVERSION
21/tcp   open ftpProFTPD 1.2.10
22/tcp   open sshOpenSSH 3.9p1 (protocol 1.99)
25/tcp   open smtp   netqmail smtpd 1.04
53/tcp   open domain
80/tcp   open http   Apache httpd 2.0.53 ((Fedora))
106/tcp  open pop3pw poppassd
110/tcp  open pop3   Courier pop3d
111/tcp  open rpcbind 2 (rpc #10)
135/tcp  filtered msrpc
139/tcp  filtered netbios-ssn
143/tcp  open imap   Courier Imapd (released 2004)
443/tcp  open ssl/http   Apache httpd 2.0.53 ((Fedora))
445/tcp  filtered microsoft-ds
465/tcp  open ssl/smtp   netqmail smtpd 1.04
593/tcp  filtered http-rpc-epmap
993/tcp  open ssl/imap   Courier Imapd (released 2004)
995/tcp  open ssl/pop3   Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql  MySQL 4.1.15
/tcp filtered krb524
8443/tcp open http   Apache httpd 1.3.33 ((Unix)  
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)

Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix

Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds

mysql

MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

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






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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

[Aron Levy]

Hi James i follow your recomendation and verify that the hash produced  
matches the password field in user exactly.


-- Aron L.

James Barros wrote:

Well, for starters don't worry about ports being open. If you werent  
able to connect, it would give you a different error message.


select password('yourpassword'); and verify that the hash produced  
matches the password field in user exactly.


-- James


On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:

Hi good afternoon, i am triying to connect with my company's mysql  
server using a client program from shell and I keep receiving the  
following answer:


[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user  'user1'@'200.93.42.209' 
(using password: YES)

[EMAIL PROTECTED] ~]#

I already checked the user was configured for any host (%), the  
port 3306 is open (checked with nmap), but i dont know what i need  
to do or see other variables.  I am 100% sure of the passwords i am  
using for this users, and i am attaching some info about the database.


Thank you in advance,


mysql select * from user;
+---+--+--+- 
+-+-+-+-+--- 
+-+---+--+--- 
++-+++
| Host  | User | Password | Select_priv |  
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv |  
Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv  | 
References_priv | Index_priv | Alter_priv |
+---+--+--+- 
+-+-+-+-+--- 
+-+---+--+--- 
++-+++
| % | user1  | 5804b8eebr456240 | N   | N
| N   | N   | N   | N | N
| N | N| N | N  |  
N   | N  | N  |
| % | user4 | 6f37d73jsdred201d | N   | N
| N   | N   | N   | N | N
| N | N| N | N  |  
N   | N  | N  |


[EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com

Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07  
09:57 VET

Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATESERVICEVERSION
21/tcp   open ftpProFTPD 1.2.10
22/tcp   open sshOpenSSH 3.9p1 (protocol 1.99)
25/tcp   open smtp   netqmail smtpd 1.04
53/tcp   open domain
80/tcp   open http   Apache httpd 2.0.53 ((Fedora))
106/tcp  open pop3pw poppassd
110/tcp  open pop3   Courier pop3d
111/tcp  open rpcbind 2 (rpc #10)
135/tcp  filtered msrpc
139/tcp  filtered netbios-ssn
143/tcp  open imap   Courier Imapd (released 2004)
443/tcp  open ssl/http   Apache httpd 2.0.53 ((Fedora))
445/tcp  filtered microsoft-ds
465/tcp  open ssl/smtp   netqmail smtpd 1.04
593/tcp  filtered http-rpc-epmap
993/tcp  open ssl/imap   Courier Imapd (released 2004)
995/tcp  open ssl/pop3   Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql  MySQL 4.1.15
/tcp filtered krb524
8443/tcp open http   Apache httpd 1.3.33 ((Unix)  
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)

Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix

Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds

mysql

MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

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









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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

[Daniel da Veiga]

On 6/7/06, Aron Levy [EMAIL PROTECTED] wrote:

Hi James i follow your recomendation and verify that the hash produced
matches the password field in user exactly.

-- Aron L.



Well, that's weird, should be working. A shot in the dark: try
starting your server with --old-passwords as an option and see if it
works.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--

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

Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhost

[James Barros]

Can this use log in from localhost successfully?
Try flushing privileges again?
If that failed, I'd drop the user and recreate?
( Theres really not alot to this, sorry I don't have any more ideas :( )

-- James

On Jun 7, 2006, at 1:07 PM, Aron Levy wrote:

Hi James i follow your recomendation and verify that the hash  
produced  matches the password field in user exactly.


-- Aron L.

James Barros wrote:

Well, for starters don't worry about ports being open. If you  
werent  able to connect, it would give you a different error message.


select password('yourpassword'); and verify that the hash  
produced  matches the password field in user exactly.


-- James


On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:

Hi good afternoon, i am triying to connect with my company's  
mysql  server using a client program from shell and I keep  
receiving the  following answer:


[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user   
'user1'@'200.93.42.209' (using password: YES)

[EMAIL PROTECTED] ~]#

I already checked the user was configured for any host (%),  
the  port 3306 is open (checked with nmap), but i dont know what  
i need  to do or see other variables.  I am 100% sure of the  
passwords i am  using for this users, and i am attaching some  
info about the database.


Thank you in advance,


mysql select * from user;
+---+--+--+-  
+-+-+-+- 
+--- +-+---+-- 
+--- ++-+ 
++
| Host  | User | Password | Select_priv |   
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv  
|  Reload_priv | Shutdown_priv |Process_priv | File_priv |  
Grant_priv  | References_priv | Index_priv | Alter_priv |
+---+--+--+-  
+-+-+-+- 
+--- +-+---+-- 
+--- ++-+ 
++
| % | user1  | 5804b8eebr456240 | N   |  
N| N   | N   | N   |  
N | N| N | N|  
N | N  |  N   | N  |  
N  |
| % | user4 | 6f37d73jsdred201d | N   |  
N| N   | N   | N   |  
N | N| N | N|  
N | N  |  N   | N  |  
N  |


[EMAIL PROTECTED] ~]# nmap -A -T4 my.domain.com

Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at  
2006-06-07  09:57 VET

Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT STATESERVICEVERSION
21/tcp   open ftpProFTPD 1.2.10
22/tcp   open sshOpenSSH 3.9p1 (protocol 1.99)
25/tcp   open smtp   netqmail smtpd 1.04
53/tcp   open domain
80/tcp   open http   Apache httpd 2.0.53 ((Fedora))
106/tcp  open pop3pw poppassd
110/tcp  open pop3   Courier pop3d
111/tcp  open rpcbind 2 (rpc #10)
135/tcp  filtered msrpc
139/tcp  filtered netbios-ssn
143/tcp  open imap   Courier Imapd (released 2004)
443/tcp  open ssl/http   Apache httpd 2.0.53 ((Fedora))
445/tcp  filtered microsoft-ds
465/tcp  open ssl/smtp   netqmail smtpd 1.04
593/tcp  filtered http-rpc-epmap
993/tcp  open ssl/imap   Courier Imapd (released 2004)
995/tcp  open ssl/pop3   Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open mysql  MySQL 4.1.15
/tcp filtered krb524
8443/tcp open http   Apache httpd 1.3.33 ((Unix)   
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)

Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix

Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds

mysql

MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

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









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






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

Re: 'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

[Gleb Paharenko]

Hello.



You should have FILE privilege.  The FILE privilege is administrative privilege 
that

can only be granted globally (using ON *.* syntax).







Jeroen Van Goey [EMAIL PROTECTED] wrote:

 Hi all,

 

 I connect via ssh from  a Linux RedHat 9 box to a remote FreeBSD

 server. There I can run MySQL and successfully add/remove tables etc.

 However, when I tried to upload a comma separated value file, I got an

 access denied error, although all privileges are granted to my

 account. What should I do/am I doing wrong?

 

 

 

 [EMAIL PROTECTED] jeroen]$ uname -rs

 Linux 2.4.21-4.EL

 

 [EMAIL PROTECTED] jeroen]$ ssh [EMAIL PROTECTED]

 Password:

 

 [EMAIL PROTECTED] ~ uname -rs

 FreeBSD 5.3-RELEASE

 

 [EMAIL PROTECTED] ~ mysql -V

 mysql  Ver 14.7 Distrib 4.1.10, for portbld-freebsd5.3 (i386)

 

 [EMAIL PROTECTED] ~ mysql -ubiogeek -p

 Enter password:

 

 mysql use biogeek;

 Database changed

 

 mysql LOAD DATA INFILE 'zipcode.data' INTO TABLE zipcodes FIELDS

 TERMINATED BY ',';

 ERROR 1045 (28000): Access denied for user 'biogeek'@'localhost'

 (using password: YES)

 

 mysql show grants for 'biogeek'@'localhost';

 +--=

 ---+

 | Grants for [EMAIL PROTECTED]   =20

  |

 +--=

 ---+

 | GRANT USAGE ON *.* TO 'biogeek'@'localhost' IDENTIFIED BY PASSWORD '*66..=

 .' |

 | GRANT ALL PRIVILEGES ON `biogeek`.* TO biogeek'@'localhost'=20

   |

 +--=

 ---+

 2 rows in set (0.00 sec)

 

 

 

 PS: I do not have root access.

 



-- 
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 1045: Access denied for user: 'root@localhost' (Using password: NO)

[Gleb Paharenko]

Hello.



 mysqladmin:connect to server at 'localhost' failed

 error: 'Can't connect to local MySQL server through socket

 '/tmp/mysql.sock' (2)'

...

 shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid

 --skip-grand-tables 

 [1] 28712

 shell Starting mysql deamon with databses from /var/db/mysql

 050303 21:04:02 mysql ended



Looks like mysqld didn't started properly. What is in the error log?





 shell mysql -u root -p

 mysql UPDATE mysql.user SET Password=PASSWORD('newpwd')  WHERE User='root';

 mysql flush privileges;

 and I checked this password another consol  I saw MySQL wasn't

 accepted  new passwd else, it didnt old password or without password.





We'll check this after solving the problem with the daemon's start.













Deniss Hennesy [EMAIL PROTECTED] wrote:

 Hi, 

 

 I have had to change mysql root passwd  

 My procedure is just below

 

 

 shell mysql -u root -p

 mysql UPDATE mysql.user SET Password=PASSWORD('newpwd')  WHERE User='root';

 mysql flush privileges;

 

 

 and I checked this password another consol  I saw MySQL wasn't

 accepted  new passwd else, it didnt old password or without password.

 

 

 

 

 

 Now neither new passwd nor old passwd also empty passwd is not acceped

 

 

 I change my mind and I tried that procedure

 

 shell kill `cat /var/db/host_name.pid`

 

 shell mysqld_safe --skip-grant-tables 

 

 shell mysqladmin -u root flush-privileges password newpwd

 

 

 mysqladmin:connect to server at 'localhost' failed

 error: 'Can't connect to local MySQL server through socket

 '/tmp/mysql.sock' (2)'

 

 Check that mysql is running and that the socket:'/tmp/mysql.sock' exits!

 

 

 3rd way is

 

 shell/usr/local/etc/rc.d/mysql-server.sh stop

 

 then

 

 shellsafe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid

 --skip-grand-tables 

 [1] 28712

 shell Starting mysql deamon with databses from /var/db/mysql

 050303 21:04:02 mysql ended

 

 

 So I suppose that it is not initialize MySQL deamon  isnt it???

 

 

 How I can recover mysql password?!??

 



-- 
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 1045: Access denied for user: 'root@localhost' (Using password: NO)

[sam wun]

Deniss Hennesy wrote:
Hi, 

I have had to change mysql root passwd  
My procedure is just below

shell mysql -u root -p
mysql UPDATE mysql.user SET Password=PASSWORD('newpwd')  WHERE User='root';
mysql flush privileges;
 

YOu may be need to execute command mysqladmin -u root password 
(yourpassword) for the creation of password. I m not sure,  not expert 
in DBA.

Sam
and I checked this password another consol  I saw MySQL wasn't
accepted  new passwd else, it didnt old password or without password.
 

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

Re: Error 1045

[Michael J. Pawlowsky]

http://dev.mysql.com/doc/mysql/fr/Access_denied.html
Philippe Cabet wrote:
Good morning,
Im a new Easyphp1-7 user. 

 

My computer environnement is Windows XP version 2002 service pack 1.
Apache 1.3.27
PHP 4.3.3
PHPMYADMIN 2.5.3
MYSQL 4.0.15
 

My problem is;
 

With EasyPhp menu, I choise Administator, PhpAdmin, Gestion BDD. 

Then I tried to set a password on my database and I receive the following
message.
 

#1045 - Accs refus pour l'utilisateur: '[EMAIL PROTECTED]' (mot de passe:
NON) 

 

I read the the Mysql document. Then I set on my config.inc.php the password
parameter equal to the password I tried to initiate on my database.
Then I trie to goback to Gestion BDD and all time I receive the screen
message #1045.
 

Other way, I would like to ignore the password I entered on my database to
continue my job.
 

Could you give me the solution? Thanks
 

Bests regard.
 

Philippe Cabet
Tl : 06 60 12 01 01
 



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

Re: Error 1045

[James E Hicks III]

On Thursday 22 July 2004 09:06 am, Jernej Koprivec wrote:
 My first contact with MySQL.
 When I try to login with the following two lines, I get an error code 1045
 mysql -h localhost -u jk -p ENTER
 PASSWORD: password

 ERROR 1045: Access denied for user: [EMAIL PROTECTED] using password: YES

 Please help.

 [EMAIL PROTECTED]

Mysql userids/passwords have nothing to do with OS userids/passwords.

http://dev.mysql.com/doc/mysql/en/User_Account_Management.html


James Hicks

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

Re: Error 1045

[Ehrwin Mina]

hi jernej,
using this command is normal:

mysql -h localhost -u jk -p ENTER

but you have to check the grants/permission you set to a particular database
name, username with its password.

use the manual for more info regarding grants.

thanks,

Ehrwin Miña

Senior System Administrator
NOC Chikka Asia, Inc.

- Original Message - 
From: James E Hicks III [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 9:33 PM
Subject: Re: Error 1045
my

 On Thursday 22 July 2004 09:06 am, Jernej Koprivec wrote:
  My first contact with MySQL.
  When I try to login with the following two lines, I get an error code
1045
  mysql -h localhost -u jk -p ENTER
  PASSWORD: password
 
  ERROR 1045: Access denied for user: [EMAIL PROTECTED] using password: YES
 
  Please help.
 
  [EMAIL PROTECTED]

 Mysql userids/passwords have nothing to do with OS userids/passwords.

 http://dev.mysql.com/doc/mysql/en/User_Account_Management.html


 James Hicks

 -- 
 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 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

[Victor Pendleton]

mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?

-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 6:55 AM
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)

User mysqladmin has not the rights to access mysql? How can that be? 
Laurent
-- 
Linux is like an Indian tent: no Windows, no Gates, and an Apache
inside!

-- 
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 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

[Laurent]

On Monday 19 July 2004 14:59, Victor Pendleton wrote:
 mysqladmin is an executable. Did you set up an user named mysqladmin that
 can connect from the localhost?

Exactly, it should be able to connect, but it doesn't. Should I change the 
name from mysqladmin to mysql or something similar? I'll try.

Laurent
-- 
Linux is like an Indian tent: no Windows, no Gates, and an Apache inside!

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

Re: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

[Thomas Spahni]

On Mon, 19 Jul 2004, Laurent wrote:

 On Monday 19 July 2004 14:59, Victor Pendleton wrote:
  mysqladmin is an executable. Did you set up an user named mysqladmin that
  can connect from the localhost?

 Exactly, it should be able to connect, but it doesn't. Should I change the
 name from mysqladmin to mysql or something similar? I'll try.

 Laurent

Laurent,

with a fresh install, use 'root' as username and no password. Be sure to
set a password later.

Thomas Spahni


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

RE: ERROR 1045: Access denied for user: 'mysqladmin@localhost' (U sing password: YES)

[Victor Pendleton]

Have you tried another user. 

-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 8:07 AM
Subject: Re: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (U
sing password: YES)

On Monday 19 July 2004 14:59, Victor Pendleton wrote:
 mysqladmin is an executable. Did you set up an user named mysqladmin
that
 can connect from the localhost?

Exactly, it should be able to connect, but it doesn't. Should I change
the 
name from mysqladmin to mysql or something similar? I'll try.

Laurent
-- 
Linux is like an Indian tent: no Windows, no Gates, and an Apache
inside!

-- 
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 1045: Access denied for user: 'mysqladmin@localhost' (Using password: YES)

[Egor Egorov]

Laurent [EMAIL PROTECTED] wrote:

 User mysqladmin has not the rights to access mysql? How can that be? 

Have you created the mysqladmin user? By default there is no such user and
it's not supposed to be there. There is no special meaning for it - mysqladmin
usually logs in as root user. 





-- 
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 1045: Access denied for user: 'foo@host' (Using password: YES)

[Egor Egorov]

Marc Tardif [EMAIL PROTECTED] wrote:
 I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release 
 9 (Shrike). First, I create a database and user to connect to this 
 database using the following commands:
 
   mysql CREATE DATABASE foo;
   mysql GRANT ALL PRIVILEGES ON foo.* TO foo@'%'
 IDENTIFIED BY 'password' WITH GRANT OPTION;
   mysql GRANT ALL PRIVILEGES ON foo.* TO [EMAIL PROTECTED]
 IDENTIFIED BY 'password' WITH GRANT OPTION;
   mysql FLUSH PRIVILEGES;
 
 Then, I try to connect to the database using the host parameter but I 
 get the following error message:
 
   # mysql --user=foo --password=password -h host foo
   ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
 
 I've only managed to find a single thread about this issue which was a 
 bug in the installation of mysql on RedHat 7. Many months have gone by 
 since then so I wonder if this is still the same issue.
 

Delete from the table User entry for user ''@'localhost' and then FLUSH PRIVILEGES.



-- 
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 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

[Michael Stassen]

Jack Woehr wrote:
I'm having a problem similar to the one mentioned in the list message 
http://lists.mysql.com/mysql/165952
   * I built, installed, and run MySQL 4.0.18
o gcc 2.95.3 on Solaris 9
   * I created a user abcd and used MyPHPAdmin to give this user a password 
xxyyzzaa
   * I can login using the command-line 'mysql -u abcd'
   * I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
   * As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have 
verified the password field for 'abcd' was instantiated.
Can anyone inform me how to cause MySQL to use passwords? Thank you.
--
Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept
http://www.well.com/~jax #  upon motionless wing; everywhere brooded stillness,
http://www.softwoehr.com #  serenity, and the peace of God. - Mark Twain
From your description, I would guess that:
 - You created the user as [EMAIL PROTECTED]
 - You have not deleted the anonymous user, ''@localhost.
When connecting, mysql looks for the best match of user and host.  Best 
match is done host first, user second.  Hence, ''@localhost is chosen over 
[EMAIL PROTECTED] when [EMAIL PROTECTED] connects.  You can verify this by entering

  SELECT CURRENT_USER();
at the mysql prompt.
You have two options:
1) Most people, I believe, solve this by deleting the anonymous user:
  mysql -u root -p mysql
  DELETE FROM user WHERE User='';
  FLUSH PRIVILEGES;
2) Create an explicit entry for [EMAIL PROTECTED], which will take precedence 
over ''@localhost, as both the host and user will match.

A few notes on security:
* Deleting the anonymous user is probably a good idea anyway.  As long as 
it's there, anyone can connect.

* Make the host part of your users as specific as possible.  Do you really 
want abcd to be able to connect from any IP in the world?  One option would 
be to only allow localhost connections.  Then abcd would have to ssh to your 
server and run mysql locally.  Of course, that requires giving abcd shell 
access, which you may not want.  In that case, consider if you can limit the 
set of machines from which connections should be allowed.  Perhaps 
[EMAIL PROTECTED] or [EMAIL PROTECTED]

* Don't put the password on the command line.  That makes it visible to 
anyone running ps at the right moment.  Instead, just use -p to be prompted 
for the password.  I.e.

  mysql -u abcd -p
See the manual http://dev.mysql.com/doc/mysql/en/Privilege_system.html for 
the details.

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

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

[Egor Egorov]

Jack Woehr [EMAIL PROTECTED] wrote:
 
 I'm having a problem similar to the one mentioned in the list message 
 http://lists.mysql.com/mysql/165952
 
 
   * I built, installed, and run MySQL 4.0.18
o gcc 2.95.3 on Solaris 9
   * I created a user abcd and used MyPHPAdmin to give this user a password 
 xxyyzzaa
   * I can login using the command-line 'mysql -u abcd'

Seems you connected as anonymous user. Check it with SELECT CURRENT_USER() function.

   * I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa'
o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: 
 YES)
   * As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have 
 verified the password field for 'abcd' was instantiated.
 
 Can anyone inform me how to cause MySQL to use passwords? Thank you.
 

Connect as a root and delete from table mysql.user entry for user ''@'localhost'. Then 
execute FLUSH PRIVILEGES command.



-- 
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 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

[Jack Woehr]

I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to 
login without password, MySQL interestingly interprets
that as even known users with passwords MUST log in without passwords. My two 
solutions were either to delete the ANY privileges or
to create a second account for [EMAIL PROTECTED] with a password required to 
supplement the [EMAIL PROTECTED] with a password required.


--
Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept
http://www.well.com/~jax #  upon motionless wing; everywhere brooded stillness,
http://www.softwoehr.com #  serenity, and the peace of God. - Mark Twain




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

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

[Michael Stassen]

Jack Woehr wrote:
I figured this out. It's the ANY setup in Privileges. Being set to 
allow ANY user to login without password, MySQL interestingly interprets 
that as even known users with passwords MUST log in without passwords.
Well, that seems to be the effect, but that's not what it is doing.  Mysql 
sorts possible matches of incoming [EMAIL PROTECTED] against the mysql.user table 
hostname first.  So, you had two matches when abcd connected from localhost: 
''@localhost and [EMAIL PROTECTED]  Explicit text is preferred to wildcards in ranking 
by specificity, so localhost is a better hostname match than %, hence 
''@localhost is chosen.

My two solutions were either to delete the ANY privileges or to create a
second account for [EMAIL PROTECTED] with a password required to
supplement the [EMAIL PROTECTED] with a password required.
Right.  Either of these will work.  If you add an [EMAIL PROTECTED] entry, when 
abcd connects from localhost, mysql finds three matches: [EMAIL PROTECTED], 
''@localhost, and [EMAIL PROTECTED]  Again, localhost is preferred over %, and within 
localhost abcd is preferred over '', so you get [EMAIL PROTECTED] as the match.

On the other hand, if you remove the anonymous user, then [EMAIL PROTECTED] is the only 
possible match when abcd connects from localhost, so it is chosen.

Michael
--
Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept
http://www.well.com/~jax #  upon motionless wing; everywhere brooded stillness,
http://www.softwoehr.com #  serenity, and the peace of God. - Mark Twain

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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[Michael Stassen]

According to the error message, [EMAIL PROTECTED] has a password, but you 
aren't supplying it.  Add -p to your commands to be prompted for the password.

If you don't know the password, see How to Reset The Root Password 
http://www.mysql.com/doc/en/Resetting_permissions.html in the manual.

Michael

Pahlevanzadeh Mohsen wrote:

Hi,When i run mysql,mysqlshow,mysqladmin  etc from
mysql command,I receive following error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
I have RH9.
Please guide me.
Yours,Mohsen.
=
-DIGITAL  SIGNATURE---
///Mohsen Pahlevanzadeh


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

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[Pahlevanzadeh Mohsen]

I didn't found hostname.pid file.
SOS SOS

--- J.R. Bullington [EMAIL PROTECTED] wrote:
 The next step is to shutdown mysqld, delete the
 mysql and temp tables from
 your /data/ folder, and then re-run the
 scripts/mysql_install_db. That will
 reinstall the mysql/hosts.frm, which will basically
 reset your root user and
 password. However, it will also kill any users you
 have created. 
 
 To reset the root password without harming other
 mysql users:
 
 Shell kill cat /path/to/mysql/data/hostname.pid
 Shell ./bin/mysqld_safe --user=mysql
 --skip-grant-tables 
 Shell mysqladmin -u root password 'newpassword'
 Shell mysqladmin shutdown
 
 Then restart the mysqld like normal. Hope this
 helps!
 
 J.R.
 


=
-DIGITAL  SIGNATURE---
///Mohsen Pahlevanzadeh
 Network administrator   programmer 
  My work phone is : +98216054096-7   
  My home phone is: +98213810146  
My emails is  
  [EMAIL PROTECTED]   
My website is: http://webnegar.net


__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/

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

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[Pahlevanzadeh Mohsen]

hi,i was attemping,But my problem didn't solved.
SOS SOS
--- J.R. Bullington [EMAIL PROTECTED] wrote:
 Did you change the mysql root password by running:
  mysqladmin -u root password 'newpassword'? 
 
 If so, try:
  mysql -u root -p  
 
 It will then prompt you to enter a password.
 
 J.R.
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:   

http://lists.mysql.com/[EMAIL PROTECTED]
 


=
-DIGITAL  SIGNATURE---
///Mohsen Pahlevanzadeh
 Network administrator   programmer 
  My work phone is : +98216054096-7   
  My home phone is: +98213810146  
My emails is  
  [EMAIL PROTECTED]   
My website is: http://webnegar.net


__
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

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

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[J.R. Bullington]

The next step is to shutdown mysqld, delete the mysql and temp tables from
your /data/ folder, and then re-run the scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically reset your root user and
password. However, it will also kill any users you have created. 

To reset the root password without harming other mysql users:

Shell kill cat /path/to/mysql/data/hostname.pid
Shell ./bin/mysqld_safe --user=mysql --skip-grant-tables 
Shell mysqladmin -u root password 'newpassword'
Shell mysqladmin shutdown

Then restart the mysqld like normal. Hope this helps!

J.R.


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

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[J.R. Bullington]

Did you change the mysql root password by running:
 mysqladmin -u root password 'newpassword'? 

If so, try:
 mysql -u root -p  

It will then prompt you to enter a password.

J.R.


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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[Victor Medina]

Hi!

You seems to have just installed mysql. The root user should be able to
acces a mysql server from anywhere by default. I don't know why you can
connect from localhost, probably you delete the [EMAIL PROTECTED]? Anyway
it is a good thing to delete the root user after the initial setup, once
you have a full rights user created that can manage the db. To do this,
loginto mysql as root, and create a full-blown user with everything
enable and give it a secure password. like this:

mysql -u root -h 192.168.1.10

Now create a full rights user like this

grant all privileges on *.* to yournewusername_here@% identified by
'passowrdhere' with grant option;

flush privileges;

This will create a new user with a set of rights comparable with the
root's own permissions.

Now, with this superuser created you can delete the root user 

use mysql
delete from user where User='root';
flush privileges;

Now logout, and login again using the new password and the new user!
voilà!

Best Regards!


On Fri, 2004-03-12 at 09:25, Leslie Vance wrote:
 Hello,
 
 I am having a hard time getting Mysql to let [EMAIL PROTECTED] connect.
 
 I am constantly getting this:
 
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
 
 when I issue mysql -u root
 
 I can log in if I use mysql -h 192.168.1.10 -u root mysql
 
 I guess I have some sort of host thing mixed up but I have tried all sorts
 of things out of the list with no avail.  I using Redhat 9 and I used the
 rpm's distributed by mysql.
 
 Thanks in advance.
 
 Les
-- 

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325 - Tél: +58-241-8507325   |
 ||geek by nature - linux by choice  |
 |...|






















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

Re: error 1045 happened randomly

[Duncan Hill]

On Monday 01 December 2003 11:46, Francis Mak wrote:

 it works successfully, however, sometimes it just give me Error 1045:
 Access Denied for user '[EMAIL PROTECTED]'
 it happens RANDOMLY.

 Could anybody please let me know how to fix this???

Remove the password from the login and the problem appears to go away.  I've 
hammered my test DBs with thousands of serial logins, and the problem only 
shows when a login has a password.


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

RE: error 1045 happened randomly

[Wouter van Vliet]

Francis Mak wrote:
 Hi,
 
 sorry if this has been answered previously, however I
 tried to google, I found a few people having this issue, but no
 solutions provided. 
 
 I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary,
 not rpm and not compiled by myself) + REDHAT 9
 
 all I did is:
 
 grant all on privileges on dbname.* to 'auser'@localhost
 identified by pass; flush privileges;
 
 and in my PHP, I provide the correct login, password and using
 'localhost'. 
 
 it works successfully, however, sometimes it just give me Error
 1045: Access Denied for user '[EMAIL PROTECTED]'
 it happens RANDOMLY.
 
 Could anybody please let me know how to fix this???
 
 Many thanks.
 
 Francis

First of all, there was no reason for the flush privileges; call. This is
automatically handled by MySQL when you use the GRANT and REVOKE statements.
Doesn't do any harm though ;).

Second, nothing is ever random in a computer. Not even the rand(); function.
When you start realizing that, you will come closer to the solution. What I
expect is that in some script you have mistyped the password or somthing.
Does this message say anything else besides 1045: Access Denied for user
'[EMAIL PROTECTED]'? Usually it also says: Using password YES or Using
password NO.

So, try to see the logic of this error. Is it always displayed when
executing the same script, are different scripts involved each time. Is the
username the error tells you the same as the username you granted access to?
Are your mysql_connect(); calls complete?

Check all that and report back ;)
Wouter




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

RE: error 1045 happened randomly

[Francis Mak]

Duncan, thanks for your tips.  I will give it a try.

so this is a known bug in mysql?  and for sure using blank password is not a
long term solutions, what if it is a share hosting env.?
any answer from mysql team?

many thanks.

francis


On Monday 01 December 2003 11:46, Francis Mak wrote:

 it works successfully, however, sometimes it just give me Error 1045:
 Access Denied for user '[EMAIL PROTECTED]'
 it happens RANDOMLY.

 Could anybody please let me know how to fix this???

Remove the password from the login and the problem appears to go away.  I've
hammered my test DBs with thousands of serial logins, and the problem only
shows when a login has a password.




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

RE: error 1045 happened randomly

[Wouter van Vliet]

Duncan Hill wrote:
 On Monday 01 December 2003 11:46, Francis Mak wrote:
 
 it works successfully, however, sometimes it just give me Error
 1045: Access Denied for user '[EMAIL PROTECTED]'
 it happens RANDOMLY.
 
 Could anybody please let me know how to fix this???
 
 Remove the password from the login and the problem appears to
 go away.  I've hammered my test DBs with thousands of serial
 logins, and the problem only shows when a login has a password.

I'm sory, and I don't want to sound disrespectfull but I do really hope you
only adviced this as a testing thing and not the real thing. (Francis: for
all I know there's no bug with passwords. I've been using it without
problems for quite a while now)

An addition to my previous post, Francis, check that you have the correct
Database selected. And .. w8, i reread your grant statement,.. looks a bit
mixed up, you probably want:

 GRANT ALL ON dbname.* to [EMAIL PROTECTED] IDENTIFIED BY 'pass';

As long as your username does not contain any strange characters, it does
not need to be quoted. Not that it is any kind of a problem to do so, and
this cannot be the problem ;) (why am I writing this then, one might wonder)

Wouter




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

Re: error 1045 happened randomly

[Duncan Hill]

On Monday 01 December 2003 12:24, Wouter van Vliet wrote:
 Duncan Hill wrote:

  Remove the password from the login and the problem appears to
  go away.  I've hammered my test DBs with thousands of serial
  logins, and the problem only shows when a login has a password.

 I'm sory, and I don't want to sound disrespectfull but I do really hope you
 only adviced this as a testing thing and not the real thing. (Francis: for
 all I know there's no bug with passwords. I've been using it without
 problems for quite a while now)

Sure.  I never said to do in a production environment - and I'd hope any admin 
worth their salt wouldn't do that.  I have reported this to the list before, 
however, that 4.1 alpha, RedHat 9 (fully patched) generates random connection 
denied messages for any client.  I've witnessed it in perl scripts, php 
scripts and the mysql command line client.

The test script I wrote sets out with a user, password and host.  While $i  
1000, connect, disconnect.  Within the first 100 attempts (normally), the 
connection will come back as access denied, and the server log also reports 
access denied.  Remove the password, and I can hit the DB 10,000 times with 
no issue.  Put a password back on, and it'll fail.

Is it my environment?  Possibly.  I'm using the RPMs from mysql.com, so I'd 
assume that hat I'm seeing is a conflict of OS + software, somewhere.

Either way, it's a bloody annoying problem, and I've got so much other work to 
do that I'm getting tempted to put null passwords into production (and not be 
worth my salt :) and rely on firewalls and ip restrictions.


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

RE: error 1045 happened randomly

[Francis Mak]

- I am 100% sure that all scripts are using include (db.php);
so all pages are using the same login and password and hostname

- since I am using password, so it shows Using Password YES as well.

- The error indeed occured on the same page. e.g. when you are viewing
index.php, it may run successfully.  and you keep on refreshing your browser
on the same page, 'sometimes' it will show the error.

for your ref., below are the connect function used in my db.php(which is
just a very common function):

$dbhost=localhost;
$dbuser=auser;
$dbpwd=pass;
$dbname=dbname;

function connectdb(){
global $dbhost, $dbuser, $dbpwd, $dbname;
($dbname) ? $dbname : $dbname = $dbuser;
$dbh = mysql_connect($dbhost, $dbuser, $dbpwd)
or die(Failed to connect database server .mysql_error().
.mysql_errno());
mysql_select_db($dbname)
or die(Unable to select database);
return $dbh;
}

thanks!!

Wouter, you replied so quick, ;)

of course I won't do blank password in a production server. But just wanna
know it is a problem in 4.1-alpha or not.
and I will try to regrant by using the statement you gave me.  thanks.
see another thread about this:
http://groups.google.com/groups?hl=zh-TWlr=ie=UTF-8oe=UTF-8threadm=bkeab
v%241bq6%241%40FreeBSD.csie.NCTU.edu.tw


-Original Message-
From: Wouter van Vliet [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 8:16 PM
To: 'Francis Mak'; [EMAIL PROTECTED]
Subject: RE: error 1045 happened randomly


First of all, there was no reason for the flush privileges; call. This is
automatically handled by MySQL when you use the GRANT and REVOKE statements.
Doesn't do any harm though ;).

Second, nothing is ever random in a computer. Not even the rand(); function.
When you start realizing that, you will come closer to the solution. What I
expect is that in some script you have mistyped the password or somthing.
Does this message say anything else besides 1045: Access Denied for user
'[EMAIL PROTECTED]'? Usually it also says: Using password YES or Using
password NO.

So, try to see the logic of this error. Is it always displayed when
executing the same script, are different scripts involved each time. Is the
username the error tells you the same as the username you granted access to?
Are your mysql_connect(); calls complete?

Check all that and report back ;)
Wouter






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

RE: error 1045 happened randomly

[Wouter van Vliet]

Francis Mak wrote:
 - I am 100% sure that all scripts are using include
 (db.php); so all pages are using the same login and
 password and hostname
 
 - since I am using password, so it shows Using Password YES as well.
 
 - The error indeed occured on the same page. e.g. when you
 are viewing index.php, it may run successfully.  and you keep
 on refreshing your browser on the same page, 'sometimes' it
 will show the error.
 
 for your ref., below are the connect function used in my
 db.php(which is just a very common function):
 
   $dbhost=localhost;
   $dbuser=auser;
   $dbpwd=pass;
   $dbname=dbname;
 
   function connectdb(){
   global $dbhost, $dbuser, $dbpwd, $dbname;
   ($dbname) ? $dbname : $dbname = $dbuser;
   $dbh = mysql_connect($dbhost, $dbuser, $dbpwd)
   or die(Failed to connect database
 server .mysql_error().
 .mysql_errno());
   mysql_select_db($dbname)
   or die(Unable to select database);
   return $dbh;
   }
 
 thanks!!
 
 Wouter, you replied so quick, ;)

Yes, I replied quick. That's because I'm at work and have nothing better to
do :D. When I'm at home it usually takes me a bit longer.

Anyways, this error, does it ONLY occur on index.php? Or also on other
pages?

Now that I have read Duncan's remarks (also quick in his replies), it may be
a bug in the alpha version. Though I still don't believe in the random part,
since there must be something internal in MySQL that does it with some kind
of pattern. 

Before you 'regrant', I'd advice you to first clear the previous grant.
You'd probably do that out of instinct, .. though. If that doesn't solve,
you might go with Duncan's thing. The No Password. But be carefull you don't
do that on your production server. Or, in my eyes better yet, downgrade to
the latest stable verion of MySQL. And compile it yourself, .. always better
since it's totally fit for your system then.




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

RE: error 1045 happened randomly

[Francis Mak]

ok, I have tried giving a blank password and after 15mins of
refreshing(previously it give me error in just around 2-3 mins.)  I don't
see the Access Denied message anymore.

Duncan, Wouter, thanks!!

though blank password is not a good solution, but at least it fix the
issue.  I think I have to go back to previous version, :(
and I am looking forward to use 4.1 stable in my next project, since the
full unicode support.
does mysql team know this issue?  I wanna report this to make this product
better.  did you, Duncan?

and Duncan said the problem occur  when user hits the DB 100 times.  how
could you monitor the number of hits??  by using what tools?

thank you guys!


-Original Message-
From: Wouter van Vliet [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 8:52 PM
To: 'Francis Mak'; [EMAIL PROTECTED]
Subject: RE: error 1045 happened randomly

Yes, I replied quick. That's because I'm at work and have nothing better to
do :D. When I'm at home it usually takes me a bit longer.

Anyways, this error, does it ONLY occur on index.php? Or also on other
pages?

Now that I have read Duncan's remarks (also quick in his replies), it may be
a bug in the alpha version. Though I still don't believe in the random part,
since there must be something internal in MySQL that does it with some kind
of pattern.

Before you 'regrant', I'd advice you to first clear the previous grant.
You'd probably do that out of instinct, .. though. If that doesn't solve,
you might go with Duncan's thing. The No Password. But be carefull you don't
do that on your production server. Or, in my eyes better yet, downgrade to
the latest stable verion of MySQL. And compile it yourself, .. always better
since it's totally fit for your system then.



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

Re: error 1045 happened randomly

[Duncan Hill]

On Monday 01 December 2003 12:51, Wouter van Vliet wrote:

 don't do that on your production server. Or, in my eyes better yet,
 downgrade to the latest stable verion of MySQL. And compile it yourself, ..
 always better since it's totally fit for your system then.

And there I was, hoping to take advantage of the query cache, sub selects etc 
that 4.1 offers :(

I'll poke 4.1.1 when it releases.  Perhaps it'll be better at this.  What I 
need to prove is whether the issue is network related.


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

Re: error 1045 happened randomly

[Duncan Hill]

On Monday 01 December 2003 13:08, Francis Mak wrote:

 though blank password is not a good solution, but at least it fix the
 issue.  I think I have to go back to previous version, :(
 and I am looking forward to use 4.1 stable in my next project, since the
 full unicode support.
 does mysql team know this issue?  I wanna report this to make this product
 better.  did you, Duncan?

Not yet.  I'm still trying to narrow it down to password length etc.  Would 
like to provide a fairly complete report when I do.

 and Duncan said the problem occur  when user hits the DB 100 times.  how
 could you monitor the number of hits??  by using what tools?

No, I said within 100 attempts :)  I haven't found any rhyme or reason to the 
interval that causes the access denied message.


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

Re: error 1045 happened randomly

[Duncan Hill]

On Monday 01 December 2003 11:46, Francis Mak wrote:

 I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and
 not compiled by myself) + REDHAT 9

Hmm, I just read this part again.. RedHat 9 is the consistent part between 
your systems and mine.  Wonder if glibc or openssl is at fault?


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

RE: error 1045 happened randomly

[Francis Mak]

um..  I  dont  know  if  glibc/openssl  will  cause  the  problem.  I  am
not  very  linux  expert  here..
but  showing  you  this  may  help  giving  out  some  info?

# rpm -qa|grep glibc
glibc-devel-2.3.2-11.9
glibc-common-2.3.2-11.9
glibc-2.3.2-11.9
glibc-kernheaders-2.4-8.10

and openssl, I am self compiled:
openssl-0.9.7c


-Original Message-
From: Duncan Hill [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 12:02 AM
To: [EMAIL PROTECTED]
Subject: Re: error 1045 happened randomly


On Monday 01 December 2003 11:46, Francis Mak wrote:

 I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary, not rpm and
 not compiled by myself) + REDHAT 9

Hmm, I just read this part again.. RedHat 9 is the consistent part between
your systems and mine.  Wonder if glibc or openssl is at fault?


--
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 1045: Acess denied for user: 'ODBC@localhost' (Using password: YES)

[Egor Egorov]

ike strong [EMAIL PROTECTED] wrote:
 Can anyone help me to figure out why suddenly I
 cant gain access into MySQL database with my password,
 which I assigned myself and which was working fine
 until yesterday when access was suddenly denied to me
 with the following meassage:
 
 Error 1045: Acess denied for user: '[EMAIL PROTECTED]'
 (Using password: YES)

You didn't specify user name.

 
 This is perhaps an old story here but very well new to
 me.
 
 Has anyone tackled or know what is causing this
 problem? I'd appreciate some help with this one.





-- 
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 1045: Acess denied for user: 'ODBC@localhost' (Using password: YES)

[TheMechE]

ike,

Well, there are quite a few wierdnessess that I have experienced.  One, for
instance, is if you are working in the GUI editor interface, and are mucking
around with the User priveleges I have actually had the GUI
wipe the passwords to null for all rows.  I'm sure its just because I'm not
aware of the assumptions being made by the Control Center.  Something like,
I will change everything with the prefix XYZ when you press this button.

Anyway, I probably created a new user for a specific database or something
for my standard user login (but for a different machine host maybe)  ( I use
explicit definitions for all hosts.) And forgot to put in the password and
that updated ALL the passwords for that login in the User table...on ALL
hosts?... which rapidly halted all working applications.

So I suggest logging into you mySQL server as root, and look at the user
table and the user privileges, use a specific SQL request, otherwise you'll
get an unreadable table in the Command Prompt viewer.
(Don't forget to set the database to the master mysql database.)
Select Host, User, Password from User

( The conclusion is that I believe you have all the passwords for your given
login will be )
Use the Update User set Password = PASSWORD(mypasshere) where User =
someone;
Don't forget to FLUSH PRIVILEGES; when you're done mucking around, or none
of you changes will take effect and you will quietly go crazy and or bald.

Does Paul.D. actually HAVE hair?  Has anyone met him in person to verify the
existance of strands. lol- ;)

_TheMechE

-Original Message-
From: ike strong [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 22, 2003 12:16 PM
To: [EMAIL PROTECTED]
Subject: Error 1045: Acess denied for user: '[EMAIL PROTECTED]' (Using
password: YES)


Can anyone help me to figure out why suddenly I
cant gain access into MySQL database with my password,
which I assigned myself and which was working fine
until yesterday when access was suddenly denied to me
with the following meassage:

Error 1045: Acess denied for user: '[EMAIL PROTECTED]'
(Using password: YES)

This is perhaps an old story here but very well new to
me.

Has anyone tackled or know what is causing this
problem? I'd appreciate some help with this one.

Thanks in advance

Ike





__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

--
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]

Fwd: Re: Error 1045: Access denied...

[Nils Valentin]

Hi Fernando;

you are logged in as anonymous user. log into mysql like this

mysql -u root -p

Hit enter if no password is set yet.

--
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

On Thursday 13 November 2003 00:47, Fernando wrote:
 Hello,
 i've just installed the 3.23.57 version in my account and i don't have root
 privileges. The problem is the if i try to create a database, like this

 mysql create database example;

 i get the following message:

 Error 1045: Access denied for user : '@localhost'.

 Is this because i'm not the root?
 If i try to use a database (one it doesn't exist) like this

 mysql use my_database;

 i get the following line

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

 I know that it should give me an error because the database doesn't exist,
 but why this access denied message? Thanks in advance!


 
 http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español

---

-- 
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

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

Re: Error 1045: Access denied...

[Nils Valentin]

Hi Patrick

How true ;-) hohohoho

Sorry for my really bad English, I just imagine that you might have had an 
experience already from somebody taking it literally ??

I will try to avoid it.

Thanks for the warning ;-)

Best regards

Nils Valentin

On Thursday 13 November 2003 01:13, Patrick Dowd wrote:
 Nils,

 I have made it a practice to never tell a user to HIT anything.  PRESS
 is much safer.

 Patrick

 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 12, 2003 8:06 AM
 To: [EMAIL PROTECTED]
 Subject: Fwd: Re: Error 1045: Access denied...




 Hi Fernando;

 you are logged in as anonymous user. log into mysql like this

 mysql -u root -p

 Hit enter if no password is set yet.

 --
 kind regards

 Nils Valentin
 Tokyo/Japan

 http://www.be-known-online.com/mysql/

 On Thursday 13 November 2003 00:47, Fernando wrote:
  Hello,
  i've just installed the 3.23.57 version in my account and i don't have

 root

  privileges. The problem is the if i try to create a database, like this
 
  mysql create database example;
 
  i get the following message:
 
  Error 1045: Access denied for user : '@localhost'.
 
  Is this because i'm not the root?
  If i try to use a database (one it doesn't exist) like this
 
  mysql use my_database;
 
  i get the following line
 
  Error 1044: Access denied for user : '@localhost' to database
  my_database.
 
  I know that it should give me an error because the database doesn't
  exist, but why this access denied message? Thanks in advance!
 
 
  
  http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español

 ---

 --
 kind regards

 Nils Valentin
 Tokyo/Japan

 http://www.be-known-online.com/mysql/

-- 
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

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

Re: Error 1045: Access denied...

[Nils Valentin]

I get your point Patrick.

I was customer support engineer myself. You cant always think about all 
eventualities can you ;-), its really hard and needs a special way of 
thinking.

Anyway that little lesson saved my day. ;-)

Thanks a lot.

Nils Valentin


On Thursday 13 November 2003 01:22, you wrote:
 Oh yes.  Some in the past have taken it literally.  Always better to be
 very simple and very explicit in your instructions to users.

 I support users in 45 retail stores across the US.  Sometimes we have to
 have them shut down an application and reboot.  Some of them have said,
 Oh, I just press the power button to shut it off?  
 Aaaa!

 Patrick

 -Original Message-
 From: Nils Valentin [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, November 12, 2003 8:18 AM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: Error 1045: Access denied...


 Hi Patrick

 How true ;-) hohohoho

 Sorry for my really bad English, I just imagine that you might have had an
 experience already from somebody taking it literally ??

 I will try to avoid it.

 Thanks for the warning ;-)

 Best regards

 Nils Valentin

 On Thursday 13 November 2003 01:13, Patrick Dowd wrote:
  Nils,
 
  I have made it a practice to never tell a user to HIT anything. 
  PRESS is much safer.
 
  Patrick
 
  -Original Message-
  From: Nils Valentin [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, November 12, 2003 8:06 AM
  To: [EMAIL PROTECTED]
  Subject: Fwd: Re: Error 1045: Access denied...
 
 
 
 
  Hi Fernando;
 
  you are logged in as anonymous user. log into mysql like this
 
  mysql -u root -p
 
  Hit enter if no password is set yet.
 
  --
  kind regards
 
  Nils Valentin
  Tokyo/Japan
 
  http://www.be-known-online.com/mysql/
 
  On Thursday 13 November 2003 00:47, Fernando wrote:
   Hello,
   i've just installed the 3.23.57 version in my account and i don't have
 
  root
 
   privileges. The problem is the if i try to create a database, like this
  
   mysql create database example;
  
   i get the following message:
  
   Error 1045: Access denied for user : '@localhost'.
  
   Is this because i'm not the root?
   If i try to use a database (one it doesn't exist) like this
  
   mysql use my_database;
  
   i get the following line
  
   Error 1044: Access denied for user : '@localhost' to database
   my_database.
  
   I know that it should give me an error because the database doesn't
   exist, but why this access denied message? Thanks in advance!
  
  
   
   http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español
 
  ---
 
  --
  kind regards
 
  Nils Valentin
  Tokyo/Japan
 
  http://www.be-known-online.com/mysql/

-- 
kind regards

Nils Valentin
Tokyo/Japan

http://www.be-known-online.com/mysql/

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

Re: Error 1045

[Director General: NEFACOMP]

Add the -p option to tell mySQL to ask for a password.

For example
c:\mysql\bin\mysql -u root -p

Or if you want to give the password without a prompt
c:\mysql\bin\mysql -u root -p YourPassWord

Or if you are connecting on another Server
c:\mysql\bin\mysql -u root -h RemoteServerAddress -p


Hope this helps


Thanks
Emery
- Original Message -
From: Stephan Wölfel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 18:05
Subject: Re: Error 1045


 But MySQL even doesn't ask me for a password but returns immediately this
 error.

 - Original Message -
 From: gerald_clark [EMAIL PROTECTED]
 To: Stephan Wölfel [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, October 13, 2003 10:14 PM
 Subject: Re: Error 1045


  You are not entering the right password.
  If you did NOT set a password for root, then leave the -p option off.
 
  Stephan Wölfel wrote:
 
  When I start MySQL with mysql -u root -p I get again the error 1045
  (Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
  What am I doing wrong ?
  
  - Original Message -
  From: gerald_clark [EMAIL PROTECTED]
  To: Stephan Wölfel [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Monday, October 13, 2003 5:54 PM
  Subject: Re: Error 1045
  
  
  
  
  Stephan Wölfel wrote:
  
  
  
  Thanks for the advise.
  However I have some additional questions:
  ad 2) How can I check the grant privileges ?
  ad 3) How can I run this as the mysql root user ?
  
  
  
  mysql -u root -p
  enter the root password you set when you installed mysql
  use mysql
  enter the grant command.
  
  
  
  - Original Message -
  From: gerald_clark [EMAIL PROTECTED]
  To: Stephan Wölfel [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Monday, October 13, 2003 4:47 PM
  Subject: Re: Error 1045
  
  
  
  
  
  
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
  
  
  http://lists.mysql.com/[EMAIL PROTECTED]
  
  
  
  
  ___
  M=FCde auf kleines Postfach? http://my-mail.ch/?redirect=3D9903
  Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
  
  
  
  
 
 
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 _
 Schlappe =DCbertragungsgrenze? http://my-mail.ch/?redirect=3D9904
 Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179


 --
 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 1045

[Stephan Wölfel]

But MySQL even doesn't ask me for a password but returns immediately this
error.

- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 10:14 PM
Subject: Re: Error 1045


 You are not entering the right password.
 If you did NOT set a password for root, then leave the -p option off.

 Stephan Wölfel wrote:

 When I start MySQL with mysql -u root -p I get again the error 1045
 (Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
 What am I doing wrong ?
 
 - Original Message -
 From: gerald_clark [EMAIL PROTECTED]
 To: Stephan Wölfel [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, October 13, 2003 5:54 PM
 Subject: Re: Error 1045
 
 
 
 
 Stephan Wölfel wrote:
 
 
 
 Thanks for the advise.
 However I have some additional questions:
 ad 2) How can I check the grant privileges ?
 ad 3) How can I run this as the mysql root user ?
 
 
 
 mysql -u root -p
 enter the root password you set when you installed mysql
 use mysql
 enter the grant command.
 
 
 
 - Original Message -
 From: gerald_clark [EMAIL PROTECTED]
 To: Stephan Wölfel [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, October 13, 2003 4:47 PM
 Subject: Re: Error 1045
 
 
 
 
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 
 
 http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 
 
 ___
 M=FCde auf kleines Postfach? http://my-mail.ch/?redirect=3D9903
 Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
 
 
 
 



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


_
Schlappe =DCbertragungsgrenze? http://my-mail.ch/?redirect=3D9904
Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179


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

Re: Error 1045

[James Cradock]

Stephan -

Connect to MySQL via a shell or command-line, change to the mysql 
database with

use mysql;

...then query the user table:

select * from user

Also, to connect to the database server as a specific user, you'll need 
to enter

mysql -u stw

or

mysql -u stw -p

...if you specified a password.

- Jim

On Monday, October 13, 2003, at 10:15 AM, Stephan Wölfel wrote:

When I try to execute grant all on *.* to stw where stw is my user 
name, I get an error 1045 (Access denied for user: '@127.0.0.1' 
(Using password: NO).
Is there a way to check for user datas ? Or how to resolve this 
problem ?

-
James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC
24 Preble Street
Portland, Maine, USA 04101
207-772-3217 (office)
207-838-8678 (mobile)
http://www.me3.com/

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

Re: Error 1045

[gerald_clark]

1. The command is not properly formed.
2. You don't have grant privileges.
3. Run this as the mysql root user.
Stephan Wölfel wrote:

When I try to execute grant all on *.* to stw where stw is my user name, I get an error 
1045 (Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a way to check for user datas ? Or how to resolve this problem ?
Stephan Wölfel
___
Schreibsüchtige gesucht! http://my-mail.ch/?redirect=9902
Heute schon Danke gesagt? Mit swissflowers.ch Blumen schenken! 
http://my-mail.ch/?redirect=9910
 



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

Re: Error 1045

[Stephan Wölfel]

Hi Jim,

thanks for the advise.
What you tell all works. But even after this I still get the same error 1045
when typing grant all on *.* to stw. Why ?

Stephan

- Original Message -
From: James Cradock [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:26 PM
Subject: Re: Error 1045


Stephan -

Connect to MySQL via a shell or command-line, change to the mysql
database with

use mysql;

...then query the user table:

select * from user

Also, to connect to the database server as a specific user, you'll need
to enter

mysql -u stw

or

mysql -u stw -p

...if you specified a password.

- Jim

On Monday, October 13, 2003, at 10:15 AM, Stephan Wölfel wrote:

 When I try to execute grant all on *.* to stw where stw is my user
 name, I get an error 1045 (Access denied for user: '@127.0.0.1'
 (Using password: NO).
 Is there a way to check for user datas ? Or how to resolve this
 problem ?

-
James Cradock, [EMAIL PROTECTED]

me3 Technology Consultants, LLC
24 Preble Street
Portland, Maine, USA 04101

207-772-3217 (office)
207-838-8678 (mobile)

http://www.me3.com/
___
Schreibs=FCchtige gesucht! http://my-mail.ch/?redirect=3D9902
Ich vermiss Di! Jetzt Blumen schenken mit swissflowers.ch! 
http://my-mail.ch/?redirect=3D9913


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

Re: Error 1045

[Stephan Wölfel]

Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I run this as the mysql root user ?

- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:47 PM
Subject: Re: Error 1045


 1. The command is not properly formed.
 2. You don't have grant privileges.
 3. Run this as the mysql root user.

 Stephan Wölfel wrote:

 When I try to execute grant all on *.* to stw where stw is my user
name, I get an error 1045 (Access denied for user: '@127.0.0.1' (Using
password: NO).
 Is there a way to check for user datas ? Or how to resolve this problem ?
 
 Stephan Wölfel

___

 Schreibsüchtige gesucht! http://my-mail.ch/?redirect=9902
 Heute schon Danke gesagt? Mit swissflowers.ch Blumen schenken!
http://my-mail.ch/?redirect=9910
 
 
 



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



Schlappe =DCbertragungsgrenze? http://my-mail.ch/?redirect=3D9904
Ich ha Di g=E4rn! Sofort Blumen schenken mit swissflowers.ch! 
http://my-mail.ch/?redirect=3D9911


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

Re: Error 1045

[James Cradock]

Stephan -

Gerald posted good instructions for doing proper privileges, but: Login 
as root, and execute this command:

GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'yourpassword';

This will apply permissions for user stw from host 127.0.0.1. You'll 
need a password to login. Run:

mysql -u stw -p

...enter the password when prompted, and you're in.

- Jim

On Monday, October 13, 2003, at 11:20 AM, Stephan Wölfel wrote:

thanks for the advise.
What you tell all works. But even after this I still get the same 
error 1045
when typing grant all on *.* to stw. Why ?

-
James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC
24 Preble Street
Portland, Maine, USA 04101
207-772-3217 (office)
207-838-8678 (mobile)
http://www.me3.com/

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

Re: Error 1045

[gerald_clark]

Stephan Wölfel wrote:

Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I run this as the mysql root user ?
mysql -u root -p
enter the root password you set when you installed mysql
use mysql
enter the grant command.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:47 PM
Subject: Re: Error 1045
 



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

Re: Error 1045

[Stephan Wölfel]

When I start MySQL with mysql -u root -p I get again the error 1045
(Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
What am I doing wrong ?

- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 5:54 PM
Subject: Re: Error 1045




 Stephan Wölfel wrote:

 Thanks for the advise.
 However I have some additional questions:
 ad 2) How can I check the grant privileges ?
 ad 3) How can I run this as the mysql root user ?
 
 mysql -u root -p
 enter the root password you set when you installed mysql
 use mysql
 enter the grant command.

 
 - Original Message -
 From: gerald_clark [EMAIL PROTECTED]
 To: Stephan Wölfel [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, October 13, 2003 4:47 PM
 Subject: Re: Error 1045
 
 
 



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


___
M=FCde auf kleines Postfach? http://my-mail.ch/?redirect=3D9903
Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179


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

Re: Error 1045

[gerald_clark]

You are not entering the right password.
If you did NOT set a password for root, then leave the -p option off.
Stephan Wölfel wrote:

When I start MySQL with mysql -u root -p I get again the error 1045
(Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
What am I doing wrong ?
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 5:54 PM
Subject: Re: Error 1045
 

Stephan Wölfel wrote:

   

Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I run this as the mysql root user ?
 

mysql -u root -p
enter the root password you set when you installed mysql
use mysql
enter the grant command.
   

- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:47 PM
Subject: Re: Error 1045


 

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

http://lists.mysql.com/[EMAIL PROTECTED]
 

   

___
M=FCde auf kleines Postfach? http://my-mail.ch/?redirect=3D9903
Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
 



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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

[Jerry M. Howell II]

 now allowing clients to login but I'm not sure what would cuse it not to
 allow root to change the password, I dubble and triple checked my entry
 but still nothing happens. Once I login to root I do the following
 
 mysql use mysql
 mysql UPDATE user SET Password= ('x')
 - WHERE user='root';
 
 Here is the response I get
 
 Query OK, 0 rows affected (0.01 sec)
 Rows matched: 4  Changed: 0  Warnings: 0
 
 Not sure why nothing is changed? Anyideas. Might root not have the
 privlage? if so, how might I be able to change the password?
 -- 
 Jerry M. Howell II
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 

Just disregard that last post. I tried to change the password to the
same password. Still, it's not letting root login with a set password.

-- 
Jerry M. Howell II

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

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

[Jerry M. Howell II]

I figured it out. Actualy silly me forgot to add the password() function
how embarising. :)
-- 
Jerry M. Howell II

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

RE: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

[Fortuno, Adam]

Jerry,

Don't forget that MySQL authenticates an entity, which is based on the user
name and host. For example, on my MySQL boxes root can only login from the
localhost. If I attempt to login with root from another host, I am denied
access.

Regards,
Adam

-Original Message-
From: Jerry M. Howell II [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 1:24 PM
To: [EMAIL PROTECTED]
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)


Hey there all,

  Here is the problem I am haveing and was wondering if anyone can help
  me here. I was getting the following error when loging into mysql

  ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
  YES)

  After searching for an answer I found the answer was to re-start
  using --skip-grant-tables and change the password then restart mysql
  useing the normal startup script. This worked well.

  The next step is where I run into problems. After I log into mysql in
  the normal mode and reset the password I go back to ERROR 1045: Access
  denied for user: '[EMAIL PROTECTED]' (Using password:YES). Also, other
  users are reporting that they can't access thier databases. Based on
  what I am seeing here I am able to login to mysql as root as long as
  there is no password. Once I set a password it wont let me connect.
  Also found that users can't login to the databases.

  Does anyone have any idea whats going on and how I might be able to
  resove this problem?

  
Thanks,
-- 
Jerry M. Howell II

-- 
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 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

[Jerry M. Howell II]

On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote:
 Jerry,
 
 Don't forget that MySQL authenticates an entity, which is based on the user
 name and host. For example, on my MySQL boxes root can only login from the
 localhost. If I attempt to login with root from another host, I am denied
 access.
 
True, by default it does, I ssh'ed into the mysql server and did it that
way. Actualy it apears that now it's not changeing the password. It's
now allowing clients to login but I'm not sure what would cuse it not to
allow root to change the password, I dubble and triple checked my entry
but still nothing happens. Once I login to root I do the following

mysql use mysql
mysql UPDATE user SET Password= ('x')
- WHERE user='root';

Here is the response I get

Query OK, 0 rows affected (0.01 sec)
Rows matched: 4  Changed: 0  Warnings: 0

Not sure why nothing is changed? Anyideas. Might root not have the
privlage? if so, how might I be able to change the password?
-- 
Jerry M. Howell II

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

Re: ERROR 1045: Access denied for user:

[Steve Pirk]

Did not see a reference to reloading tables in the docs.
This is just weird enough for me to vpn in and try again :-)
Thanks!

--
Steve (egrep)

On Fri, 7 Mar 2003, Ben Balbo wrote:

 Hi Steve,

 Really silly question, but you are reloading the tables once you
 change the grants, aren't you :-)

 mysqladmin -p reload

 B.

 In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.

  Mysql version 3.23.55 Slackware linux 8.0
  Mysql version 3.23.55 OpenBSD

  I have tried 3 versions of mysql on linux and
  on OpenBSD. I have even tried compiling on linux
  from the source tarball.

  Without the GRANT privs to allow network access:
 mysql GRANT ALL PRIVILEGES ON db.*
  - TO user@'192.58.197.0/255.255.255.0';
  (example), I would get a you are not allowed to connect
  error. Once I applied the grant to the user:
 mysql GRANT ALL PRIVILEGES ON db.*
  - TO user@'%'
  the users table shows:
  | Host| User  |
  ---
  | %   | user  |

  If I coonect to the database without a host, or
  with host set to localhost, I can connect fine. If
  I connect from another machine, or just use the DNS
  name on the local machine, I get:
  shell mysql -h 192.168.1.24 -u test -p

  ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
  password: YES)

  I have even tried connecting using the IP address. I have poured
  over the docs, and have tried all the scenarios of add hostnames
  to /etc/hosts etc. I even complied from source (glibc problem).
  No luck at all... Any ideas? I really need network access to the
  database.
  --
  Steve (egrep)


  -
  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



-
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 1045: Access denied for user:

[Steve Pirk]

Tried this... no go... The wierd part, is that localhost
works fine, but I cannot connect locally if I use the
hostname. Thanks for the help!

(maybe I should go back to an old version of mysql :-)

--
Steve (egrep)

On Fri, 7 Mar 2003, Ben Balbo wrote:

 Hi Steve,

 Really silly question, but you are reloading the tables once you
 change the grants, aren't you :-)

 mysqladmin -p reload

 B.

 In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.

  Mysql version 3.23.55 Slackware linux 8.0
  Mysql version 3.23.55 OpenBSD

  I have tried 3 versions of mysql on linux and
  on OpenBSD. I have even tried compiling on linux
  from the source tarball.

  Without the GRANT privs to allow network access:
 mysql GRANT ALL PRIVILEGES ON db.*
  - TO user@'192.58.197.0/255.255.255.0';
  (example), I would get a you are not allowed to connect
  error. Once I applied the grant to the user:
 mysql GRANT ALL PRIVILEGES ON db.*
  - TO user@'%'
  the users table shows:
  | Host| User  |
  ---
  | %   | user  |

  If I coonect to the database without a host, or
  with host set to localhost, I can connect fine. If
  I connect from another machine, or just use the DNS
  name on the local machine, I get:
  shell mysql -h 192.168.1.24 -u test -p

  ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
  password: YES)

  I have even tried connecting using the IP address. I have poured
  over the docs, and have tried all the scenarios of add hostnames
  to /etc/hosts etc. I even complied from source (glibc problem).
  No luck at all... Any ideas? I really need network access to the
  database.
  --
  Steve (egrep)


  -
  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



-
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 1045: Access denied for user:

[Steve Pirk]

Yep, tried that... but I will try it again...

--
Steve (egrep)

On Thu, 6 Mar 2003, Roger Davis wrote:

 Or

 mysql flush privileges;

 Roger

 -Original Message-
 From: Ben Balbo [mailto:[EMAIL PROTECTED]
 Sent: Thursday, March 06, 2003 7:08 PM
 To: MySQL List
 Subject: Re: ERROR 1045: Access denied for user:


 Hi Steve,

 Really silly question, but you are reloading the tables once you
 change the grants, aren't you :-)

 mysqladmin -p reload

 B.

 In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.

  Mysql version 3.23.55 Slackware linux 8.0
  Mysql version 3.23.55 OpenBSD

  I have tried 3 versions of mysql on linux and
  on OpenBSD. I have even tried compiling on linux
  from the source tarball.

  Without the GRANT privs to allow network access:
 mysql GRANT ALL PRIVILEGES ON db.*
  - TO user@'192.58.197.0/255.255.255.0';
  (example), I would get a you are not allowed to connect
  error. Once I applied the grant to the user:
 mysql GRANT ALL PRIVILEGES ON db.*
  - TO user@'%'
  the users table shows:
  | Host| User  |
  ---
  | %   | user  |

  If I coonect to the database without a host, or
  with host set to localhost, I can connect fine. If
  I connect from another machine, or just use the DNS
  name on the local machine, I get:
  shell mysql -h 192.168.1.24 -u test -p

  ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
  password: YES)

  I have even tried connecting using the IP address. I have poured
  over the docs, and have tried all the scenarios of add hostnames
  to /etc/hosts etc. I even complied from source (glibc problem).
  No luck at all... Any ideas? I really need network access to the
  database.
  --
  Steve (egrep)


  -
  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


 -
 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 1045: Access denied for user:

[Paul DuBois]

At 11:07 +1100 3/7/03, Ben Balbo wrote:
Hi Steve,

Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)
mysqladmin -p reload

B.
Yep, it's silly. :-)  Because GRANT automatically refreshes the
in-memory copies of the grant tables.
Steve, try this:

mysql DELETE FROM mysql.user WHERE User = '';
mysql FLUSH PRIVILEGES;
(FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies
the grant tables, and you have to tell the server to refresh the in-memory
copies).
Then try to connect again.  Bet it'll work.

In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.

 Mysql version 3.23.55 Slackware linux 8.0
 Mysql version 3.23.55 OpenBSD

 I have tried 3 versions of mysql on linux and
 on OpenBSD. I have even tried compiling on linux
 from the source tarball.

 Without the GRANT privs to allow network access:
mysql GRANT ALL PRIVILEGES ON db.*
 - TO user@'192.58.197.0/255.255.255.0';
 (example), I would get a you are not allowed to connect
 error. Once I applied the grant to the user:
mysql GRANT ALL PRIVILEGES ON db.*
 - TO user@'%'
 the users table shows:
 | Host| User  |
 ---
 | %   | user  |

 If I coonect to the database without a host, or
 with host set to localhost, I can connect fine. If
 I connect from another machine, or just use the DNS
 name on the local machine, I get:
 shell mysql -h 192.168.1.24 -u test -p

 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
 password: YES)

 I have even tried connecting using the IP address. I have poured
 over the docs, and have tried all the scenarios of add hostnames
 to /etc/hosts etc. I even complied from source (glibc problem).
 No luck at all... Any ideas? I really need network access to the
 database.
 --
  Steve (egrep)


-
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 1045: Access denied for user:

[Steve Pirk]

That was a great suggestion (getting rid of the
blank user), but alas, it did not work. Here
are the three examples: (first one fail because the
blank user was removed)

[EMAIL PROTECTED]:~$ mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)

[EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5711 to server version: 3.23.55

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

mysql quit
Bye

[EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)

--
Steve (egrep)

On Thu, 6 Mar 2003, Paul DuBois wrote:

 At 11:07 +1100 3/7/03, Ben Balbo wrote:
 Hi Steve,
 
 Really silly question, but you are reloading the tables once you
 change the grants, aren't you :-)
 
 mysqladmin -p reload
 
 B.

 Yep, it's silly. :-)  Because GRANT automatically refreshes the
 in-memory copies of the grant tables.

 Steve, try this:

 mysql DELETE FROM mysql.user WHERE User = '';
 mysql FLUSH PRIVILEGES;

 (FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies
 the grant tables, and you have to tell the server to refresh the in-memory
 copies).

 Then try to connect again.  Bet it'll work.

 
 In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.
 
   Mysql version 3.23.55 Slackware linux 8.0
   Mysql version 3.23.55 OpenBSD
 
   I have tried 3 versions of mysql on linux and
   on OpenBSD. I have even tried compiling on linux
   from the source tarball.
 
   Without the GRANT privs to allow network access:
 mysql GRANT ALL PRIVILEGES ON db.*
   - TO user@'192.58.197.0/255.255.255.0';
   (example), I would get a you are not allowed to connect
   error. Once I applied the grant to the user:
 mysql GRANT ALL PRIVILEGES ON db.*
   - TO user@'%'
   the users table shows:
   | Host| User  |
   ---
   | %   | user  |
 
   If I coonect to the database without a host, or
   with host set to localhost, I can connect fine. If
   I connect from another machine, or just use the DNS
   name on the local machine, I get:
   shell mysql -h 192.168.1.24 -u test -p
 
   ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
   password: YES)
 
   I have even tried connecting using the IP address. I have poured
   over the docs, and have tried all the scenarios of add hostnames
   to /etc/hosts etc. I even complied from source (glibc problem).
   No luck at all... Any ideas? I really need network access to the
   database.
   --
Steve (egrep)


 -
 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 1045: Access denied for user:

[Steve Pirk]

I just installed the standard-4.0.11 binary and
the same problem exists. Error 1130: this host
is not allowed to connect. Run the grant and flush
privs. Access denied...

--
Steve (egrep)

On Fri, 7 Mar 2003, Steve Pirk wrote:

 That was a great suggestion (getting rid of the
 blank user), but alas, it did not work. Here
 are the three examples: (first one fail because the
 blank user was removed)

 [EMAIL PROTECTED]:~$ mysql
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)

 [EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p
 Enter password:
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 5711 to server version: 3.23.55

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

 mysql quit
 Bye

 [EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p
 Enter password:
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
 password: YES)

 --
 Steve (egrep)

 On Thu, 6 Mar 2003, Paul DuBois wrote:

  At 11:07 +1100 3/7/03, Ben Balbo wrote:
  Hi Steve,
  
  Really silly question, but you are reloading the tables once you
  change the grants, aren't you :-)
  
  mysqladmin -p reload
  
  B.
 
  Yep, it's silly. :-)  Because GRANT automatically refreshes the
  in-memory copies of the grant tables.
 
  Steve, try this:
 
  mysql DELETE FROM mysql.user WHERE User = '';
  mysql FLUSH PRIVILEGES;
 
  (FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies
  the grant tables, and you have to tell the server to refresh the in-memory
  copies).
 
  Then try to connect again.  Bet it'll work.
 
  
  In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.
  
Mysql version 3.23.55 Slackware linux 8.0
Mysql version 3.23.55 OpenBSD
  
I have tried 3 versions of mysql on linux and
on OpenBSD. I have even tried compiling on linux
from the source tarball.
  
Without the GRANT privs to allow network access:
  mysql GRANT ALL PRIVILEGES ON db.*
- TO user@'192.58.197.0/255.255.255.0';
(example), I would get a you are not allowed to connect
error. Once I applied the grant to the user:
  mysql GRANT ALL PRIVILEGES ON db.*
- TO user@'%'
the users table shows:
| Host| User  |
---
| %   | user  |
  
If I coonect to the database without a host, or
with host set to localhost, I can connect fine. If
I connect from another machine, or just use the DNS
name on the local machine, I get:
shell mysql -h 192.168.1.24 -u test -p
  
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
  
I have even tried connecting using the IP address. I have poured
over the docs, and have tried all the scenarios of add hostnames
to /etc/hosts etc. I even complied from source (glibc problem).
No luck at all... Any ideas? I really need network access to the
database.
--
 Steve (egrep)
 
 
  -
  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



-
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 1045: Access denied for user:

[gerald_clark]

You grant IP address does not match the IP address of the client failing 
the connection.

Steve Pirk wrote:

That was a great suggestion (getting rid of the
blank user), but alas, it did not work. Here
are the three examples: (first one fail because the
blank user was removed)
[EMAIL PROTECTED]:~$ mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5711 to server version: 3.23.55
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql quit
Bye
[EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
--
Steve (egrep)
On Thu, 6 Mar 2003, Paul DuBois wrote:

 

At 11:07 +1100 3/7/03, Ben Balbo wrote:
   

Hi Steve,

Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)
mysqladmin -p reload

B.
 

Yep, it's silly. :-)  Because GRANT automatically refreshes the
in-memory copies of the grant tables.
Steve, try this:

mysql DELETE FROM mysql.user WHERE User = '';
mysql FLUSH PRIVILEGES;
(FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies
the grant tables, and you have to tell the server to refresh the in-memory
copies).
Then try to connect again.  Bet it'll work.

   

In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.

 

Mysql version 3.23.55 Slackware linux 8.0
Mysql version 3.23.55 OpenBSD
   

I have tried 3 versions of mysql on linux and
on OpenBSD. I have even tried compiling on linux
from the source tarball.
   

Without the GRANT privs to allow network access:
   

mysql GRANT ALL PRIVILEGES ON db.*
 

- TO user@'192.58.197.0/255.255.255.0';
(example), I would get a you are not allowed to connect
error. Once I applied the grant to the user:
   

mysql GRANT ALL PRIVILEGES ON db.*
 

- TO user@'%'
the users table shows:
| Host| User  |
---
| %   | user  |
   

If I coonect to the database without a host, or
with host set to localhost, I can connect fine. If
I connect from another machine, or just use the DNS
name on the local machine, I get:
shell mysql -h 192.168.1.24 -u test -p
   

ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
   

I have even tried connecting using the IP address. I have poured
over the docs, and have tried all the scenarios of add hostnames
to /etc/hosts etc. I even complied from source (glibc problem).
No luck at all... Any ideas? I really need network access to the
database.
--
   

 Steve (egrep)
 

-
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
 



-
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 1045: Access denied for user:

[Steve Pirk]

Both ip's are in the user table along with the
% wildcard.

--
Steve (egrep)

On Fri, 7 Mar 2003, gerald_clark wrote:

 You grant IP address does not match the IP address of the client failing
 the connection.

 Steve Pirk wrote:

 That was a great suggestion (getting rid of the
 blank user), but alas, it did not work. Here
 are the three examples: (first one fail because the
 blank user was removed)
 
 [EMAIL PROTECTED]:~$ mysql
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
 
 [EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p
 Enter password:
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 5711 to server version: 3.23.55
 
 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
 mysql quit
 Bye
 
 [EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p
 Enter password:
 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
 password: YES)
 
 --
 Steve (egrep)
 
 On Thu, 6 Mar 2003, Paul DuBois wrote:
 
 
 
 At 11:07 +1100 3/7/03, Ben Balbo wrote:
 
 
 Hi Steve,
 
 Really silly question, but you are reloading the tables once you
 change the grants, aren't you :-)
 
 mysqladmin -p reload
 
 B.
 
 
 Yep, it's silly. :-)  Because GRANT automatically refreshes the
 in-memory copies of the grant tables.
 
 Steve, try this:
 
 mysql DELETE FROM mysql.user WHERE User = '';
 mysql FLUSH PRIVILEGES;
 
 (FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies
 the grant tables, and you have to tell the server to refresh the in-memory
 copies).
 
 Then try to connect again.  Bet it'll work.
 
 
 
 In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.
 
 
 
  Mysql version 3.23.55 Slackware linux 8.0
  Mysql version 3.23.55 OpenBSD
 
 
  I have tried 3 versions of mysql on linux and
  on OpenBSD. I have even tried compiling on linux
  from the source tarball.
 
 
  Without the GRANT privs to allow network access:
 
 
 mysql GRANT ALL PRIVILEGES ON db.*
 
 
  - TO user@'192.58.197.0/255.255.255.0';
  (example), I would get a you are not allowed to connect
  error. Once I applied the grant to the user:
 
 
 mysql GRANT ALL PRIVILEGES ON db.*
 
 
  - TO user@'%'
  the users table shows:
  | Host| User  |
  ---
  | %   | user  |
 
 
  If I coonect to the database without a host, or
  with host set to localhost, I can connect fine. If
  I connect from another machine, or just use the DNS
  name on the local machine, I get:
  shell mysql -h 192.168.1.24 -u test -p
 
 
  ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
  password: YES)
 
 
  I have even tried connecting using the IP address. I have poured
  over the docs, and have tried all the scenarios of add hostnames
  to /etc/hosts etc. I even complied from source (glibc problem).
  No luck at all... Any ideas? I really need network access to the
  database.
  --
 
 
   Steve (egrep)
 
 
 -
 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
 
 
 
 





-
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 1045: Access denied for user:

[Ben Balbo]

Hi Steve,

Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)

mysqladmin -p reload

B.

In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.

 Mysql version 3.23.55 Slackware linux 8.0
 Mysql version 3.23.55 OpenBSD

 I have tried 3 versions of mysql on linux and
 on OpenBSD. I have even tried compiling on linux
 from the source tarball.

 Without the GRANT privs to allow network access:
mysql GRANT ALL PRIVILEGES ON db.*
 - TO user@'192.58.197.0/255.255.255.0';
 (example), I would get a you are not allowed to connect
 error. Once I applied the grant to the user:
mysql GRANT ALL PRIVILEGES ON db.*
 - TO user@'%'
 the users table shows:
 | Host| User  |
 ---
 | %   | user  |

 If I coonect to the database without a host, or
 with host set to localhost, I can connect fine. If
 I connect from another machine, or just use the DNS
 name on the local machine, I get:
 shell mysql -h 192.168.1.24 -u test -p

 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
 password: YES)

 I have even tried connecting using the IP address. I have poured
 over the docs, and have tried all the scenarios of add hostnames
 to /etc/hosts etc. I even complied from source (glibc problem).
 No luck at all... Any ideas? I really need network access to the
 database.
 --
 Steve (egrep)


 -
 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 1045: Access denied for user:

[Roger Davis]

Or

mysql flush privileges;

Roger

-Original Message-
From: Ben Balbo [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 7:08 PM
To: MySQL List
Subject: Re: ERROR 1045: Access denied for user:


Hi Steve,

Really silly question, but you are reloading the tables once you
change the grants, aren't you :-)

mysqladmin -p reload

B.

In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM.

 Mysql version 3.23.55 Slackware linux 8.0
 Mysql version 3.23.55 OpenBSD

 I have tried 3 versions of mysql on linux and
 on OpenBSD. I have even tried compiling on linux
 from the source tarball.

 Without the GRANT privs to allow network access:
mysql GRANT ALL PRIVILEGES ON db.*
 - TO user@'192.58.197.0/255.255.255.0';
 (example), I would get a you are not allowed to connect
 error. Once I applied the grant to the user:
mysql GRANT ALL PRIVILEGES ON db.*
 - TO user@'%'
 the users table shows:
 | Host| User  |
 ---
 | %   | user  |

 If I coonect to the database without a host, or
 with host set to localhost, I can connect fine. If
 I connect from another machine, or just use the DNS
 name on the local machine, I get:
 shell mysql -h 192.168.1.24 -u test -p

 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
 password: YES)

 I have even tried connecting using the IP address. I have poured
 over the docs, and have tried all the scenarios of add hostnames
 to /etc/hosts etc. I even complied from source (glibc problem).
 No luck at all... Any ideas? I really need network access to the
 database.
 --
 Steve (egrep)


 -
 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


-
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 1045: Access denied for user: 'root@localhost'

[Tom McDonough]

I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?

Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From: Victoria Reznichenko
Date: Tue, 23 Apr 2002 16:38:01 +0300


 [root@omsrh etc]# mysql
 ERROR 1045: Access denied for user: 'root@localhost' (Using password:
NO)

   It means that anonymous user doesn't have any privileges ...
   Unix 'root' user and 'root' user in MySQL are different ...




-
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: Re: ERROR 1045: Access denied for user: 'root@localhost'

[Victoria Reznichenko]

Tom,
Thursday, April 25, 2002, 5:40:11 PM, you wrote:

TM I am having the same problem and cannot find any document which can get
TM me beyond Access denied...

TM Could you explain the difference between Linux 'root' user and 'root'
TM user in MySQL?

MySQL user 'root' is usual user, it's a user with name 'root'. :) By default 'root' 
user in MySQL has all privileges, but you can change it. When you connect to the MySQL
server, run MySQL utilities you can use option '--user=user_name'.
MySQL uses user_name to indentified user (password and host also
are used for identification). If you don't specify user name, it means
that you connected as anonymous user. Anonymous users are defined by
inserting entries with User='' into the mysql.user table or creating
an user with an empty name with the GRANT command.

'root' user in Linux is a superuser of OS, not of MySQL.

Look at the MySQL documentation, there are a LOT a of info about
privilege system in MySQL:
  http://www.mysql.com/doc/P/r/Privilege_system.html
  http://www.mysql.com/doc/U/s/User_Account_Management.html

TM Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
TM From: Victoria Reznichenko
TM Date: Tue, 23 Apr 2002 16:38:01 +0300


 [root@omsrh etc]# mysql
 ERROR 1045: Access denied for user: 'root@localhost' (Using password:
TM NO)

TMIt means that anonymous user doesn't have any privileges ...
TMUnix 'root' user and 'root' user in MySQL are different ...




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




-
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 1045: Access denied for user: 'root@localhost'

[Gelu]

Hi,
After installation it's necessary to run mysq_install_db.sh.This script have
some routines to resolve the host,create system mySQL tables and write the
default option in this tables.For this reason, if you have some network
configuration problem, it's a good idea to use '-h' option and said to
mysql daemon what host must be resolved.
Eg:

mysql -u root -h host_name_of_your_Linux_machine -p

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]

- Original Message -
From: Tom McDonough [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 5:40 PM
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'


 I am having the same problem and cannot find any document which can get
 me beyond Access denied...
 Could you explain the difference between Linux 'root' user and 'root'
 user in MySQL?

 Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
 From: Victoria Reznichenko
 Date: Tue, 23 Apr 2002 16:38:01 +0300


  [root@omsrh etc]# mysql
  ERROR 1045: Access denied for user: 'root@localhost' (Using password:
 NO)

It means that anonymous user doesn't have any privileges ...
Unix 'root' user and 'root' user in MySQL are different ...




 -
 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 1045: Access denied for user: 'root@localhost'

[Gurhan Ozen]

MySQL 'root' user has got nothing to do with Unix 'root' user. Quoted from
http://www.mysql.com/doc/C/h/Changing_MySQL_user.html  is
Note that accessing MySQL as root, by supplying -u root on the command
line, has nothing to do with MySQL running as the Unix root user, or,
indeed, as another Unix user. The access permissions and user names of MySQL
are completely separate from Unix user names. The only connection with Unix
user names is that if you don't provide a -u option when you invoke a client
program, the client will try to connect using your Unix login name as your
MySQL user name.

You might also want to check out:
http://www.mysql.com/doc/U/s/User_Account_Management.html


Gurhan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom
McDonough
Sent: Thursday, April 25, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'


I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?

Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From: Victoria Reznichenko
Date: Tue, 23 Apr 2002 16:38:01 +0300


 [root@omsrh etc]# mysql
 ERROR 1045: Access denied for user: 'root@localhost' (Using password:
NO)

   It means that anonymous user doesn't have any privileges ...
   Unix 'root' user and 'root' user in MySQL are different ...




-
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 1045: Access denied for user: 'root@localhost'

[Victoria Reznichenko]

Tewfic,
Monday, April 22, 2002, 10:07:06 PM, you wrote:

 Hello, i'm having a problem accessing mysql database.  I don't recall
 setting a password for root, but when i try to set that password.  This is
 happening right after i run  mysql_install_db
 
 [root@omsrh etc]# mysql -u root -p
 Enter password:**
 ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

If you didn't set password, you don't have to use '-p' option for
connection. 

If you want to set password, please, chaeck the following link:
   http://www.mysql.com/doc/P/a/Passwords.html

 [root@omsrh etc]# mysql
 ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

   It means that anonymous user doesn't have any privileges ...
   Unix 'root' user and 'root' user in MySQL are different ...

 I was able access Mysql not being root, but couldn't get access to 'mysql'
 database to change user options and all.  
 
 When accessing mysql as a user, I am unable to create databases.
 
 
 When using skip-grant-table i get ...
 
 [root@omsrh etc]# mysql -u root
 mysql: unrecognized option `--skip-grant-table'

Use --skip-grant-tables option, not --skip-grant-table ...

 Your help will be greatly appreciated.




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




-
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 1045 - Access denied

[Carsten H. Pedersen]

 Hello,

 I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED]
 (using password: YES)
 errors.  I'm connecting to this MySQL server from a remote site.

 I don't see any reason for this.  I KNOW that my password is correct.  In
 the user table, the Host is set to % for the mysql user.  There's also
 another entry for the mysql user and the host on that is set to
 localhost.  Could having 2 of the same usernames have an effect on this?
 I really don't see any reason that I can't connect to this MySQL
 server from
 a remote site.

How were the entries created? Using GRANT ... or by editing
the user table directly? In the latter case, did you remember
to FLUSH PRIVILEGES?

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq



-
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 1045 - Access denied

[Tyler Longren]

Hello,

I created the entries by adding them manually to the table (not using
GRANT).  And yes, I did run FLUSH PRIVILEGES.  Anything else I should try
doing?  The MySQL manual didn't really provide much help.

Thanks!
Tyler

- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2001 3:28 PM
Subject: RE: Error 1045 - Access denied


  Hello,
 
  I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED]
  (using password: YES)
  errors.  I'm connecting to this MySQL server from a remote site.
 
  I don't see any reason for this.  I KNOW that my password is correct.
In
  the user table, the Host is set to % for the mysql user.  There's
also
  another entry for the mysql user and the host on that is set to
  localhost.  Could having 2 of the same usernames have an effect on
this?
  I really don't see any reason that I can't connect to this MySQL
  server from
  a remote site.

 How were the entries created? Using GRANT ... or by editing
 the user table directly? In the latter case, did you remember
 to FLUSH PRIVILEGES?

 / Carsten
 --
 Carsten H. Pedersen
 keeper and maintainer of the bitbybit.dk MySQL FAQ
 http://www.bitbybit.dk/mysqlfaq



 -
 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