SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:49 AM
| ||||
| ||||
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' Hi. Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): --------- [root@server]# /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('xxxxxx'); -------- And killed the process and restarted: -------- [root@server ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql & [1] 2494 [root@server ~]# 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?      |
|
02-28-2008, 05:49 AM
| ||||
| ||||
| Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' 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('xxxxxxx') where user = 'root' and host='localhost'; On 2/20/07, thomas Armstrong <tarmstrong@gmail.com> wrote: > Hi. > > Using mySQL 4.1.22 on Linux, I got this error message suddenly this > morning (it worked ok yesterday): > --------- > [root@server]# /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('xxxxxx'); > -------- > > And killed the process and restarted: > -------- > [root@server ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql & > [1] 2494 > [root@server ~]# 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? > |
 |
« ERROR 1045 (28000): Access denied for user 'root'@'localhost'
|
RE: MySQL Daylight Savings Time Patch »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:22 AM.
