Модераторы: SLEDopit, Модераторы разделов
Код: Выделить всё
Ошибка
Ответ MySQL: Документация
#1045 - Access denied for user 'root'@'localhost' (using password: NO)Код: Выделить всё
#mysqladmin -u root password ''Код: Выделить всё
error: 'Access denied for user 'root'@'localhost' (using password: NO)'Кратко:
1. перезапустить mysqld с опцией --skip-grant-tables
2. mysqladmin -h хост -u пользователь password 'новый пароль'
Техника изменения забытого административного MySQL пароля [исправить]
Останавливаем MySQL:
/etc/init.d/mysql stop
Запускаем в режиме без проверки прав доступа:
/usr/bin/mysqld_safe --skip-grant-tables &
Соединяемся как root без пароля:
mysql --user=root mysql
Обновляем пароль:
mysql> update user set Password=PASSWORD('новый пароль') WHERE User='root';
mysql> flush privileges;
Завершаем работу mysqld_safe:
fg
"Ctrl+c"
Запускаем MySQL в обычном режиме.
/etc/init.d/mysql start
Код: Выделить всё
UPDATE user SET Password=NULL WHERE Host='localhost' AND User='root';Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
080207 17:14:49 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080207 17:14:49 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080207 17:14:50 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080207 17:14:50 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080207 17:14:50 InnoDB: Started; log sequence number 0 0
080207 17:14:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
080207 17:14:50 mysqld ended
Installing MySQL system tables...
ERROR: 1062 Duplicate entry 'localhost-' for key 1
080207 17:58:14 [ERROR] Aborting
080207 17:58:14 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
080207 17:58:57 mysqld started
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
080207 17:58:57 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
080207 17:58:57 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
080207 17:58:57 InnoDB: Started; log sequence number 0 43655
080207 17:58:57 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080207 17:58:57 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
080207 17:58:57 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
080207 17:58:57 mysqld ended
Cannot load mysql extension. Please check your PHP configuration.
В конечном итоге все вернулось на круги своя - надо задать пароль. Идем на в статьи из вики - http://wiki.archlinux.org/index.php/LAMPSetup MySQL support
Do these steps only if you want MySQL support. Configure MySQL as described here: MySQL
* Edit /etc/php/php.ini (this is in /usr/etc on older systems) to uncomment the following line (By removing:
;extension=mysql.so
* You can add minor privileged users for your web scripts by editing the tables found in the mysql database. You have to restart MySQL for changes to take effect. Don't forget to check the mysql/users table. If there's a second entry for root and your hostname is left with no password set, everybody from your host probably could gain full access. Perhaps see next section for these jobs.
* You can get the "error no. 2013: Lost Connection to mysql server during query" message instantly whenever you try to connect to the MySQL daemon by TCP/IP. This is the TCP wrappers system (tcpd), which uses the hosts_access(5) system to allow or disallow connections.
* If you're running into this problem, be sure to add this to your /etc/hosts.allow file:
# mysqld : ALL : ALLOW
# mysqld-max : ALL : ALLOW
# and similar for the other MySQL daemons.
* Notes: The examples above are the simplest case, telling tcpd to allow connections from anywhere. You may wish to use a more-appropriate choice of permissible sources instead of ALL. Just make sure that localhost and the IP address (numeric or DNS) of the interface by which you connect are specified.
* You might also need to edit /etc/my.cnf and comment out the skip-networking line as such:
skip-networking
to
#skip-networking
If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. However, it is recommended to set a password for each account.
mysql> UPDATE user SET Password=NULL WHERE User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> UPDATE user SET Password=PASSWORD('abc') WHERE User='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Ладно хоть mysqld начал запускаться. Начинаю все больше и больше разочаровываться в арче.. Когда нужно было все руками настраивать, я не так уж был и расстроен - наоборот многое узнал. Но когда тут на пустом месте, какие-то проблемы, которые в других дистрибутивах не проявляются..
mysql> UPDATE user SET Password=PASSWORD('abc') WHERE User='root';
Query OK, 0 rows affected (0.00 sec)
Код: Выделить всё
sudo mysql_install_db
Installing MySQL system tables...
ERROR: 1062 Duplicate entry 'localhost-' for key 1
080208 10:00:28 [ERROR] Aborting
080208 10:00:28 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Installing MySQL system tables...
080209 2:04:53 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
080209 2:04:53 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Installation of system tables failed!
