wstuermer
Active Member
Code:
mysql -uroot -p
Falls Du das Passwort nicht mehr hast: MySQL: Root-Passwort vergessen - huschi.net
mysql -uroot -p
mysqladmin -u root password "MeinPass"
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Dafür steht in der Man-Page Folgendes:mysqladmin -u root password "MeinPass"
OPTION SYNOPSIS
mysqladmin [-#|--debug= logfile] [-f|--force] [-?|--help]
[--character-sets-dir=directory] [-C|--compress]
[-h|--host=[#]] [-p[pwd]] [--password=[pwd]] [-P|--port=
pnum] [-i|--sleep= sec] [-E|--vertical] [-s|--silent]
[-S|--socket= #] [-r|--relative] [-t|--timeout= #]
[-u|--user= uname] [-v|--verbose] [-V|--version]
[-w|--wait[=retries]]
update user set host='%' where user='huschi';
update db set host='%' where user='huschi';
flush privileges;
exit;
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
flush privileges;
Query OK, 0 rows affected (0.00 sec)
l-wilkes:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
l-wilkes:~# mysqld_safe --skip-grant-tables&
[1] 13651
l-wilkes:~# Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[13722]: started
l-wilkes:~# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.32-Debian_7etch10-log Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> UPDATE mysql.user SET Password=PASSWORD('meinPass') WHERE User='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
Bye
l-wilkes:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqldSTOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[16350]: ended
.
[1]+ Done mysqld_safe --skip-grant-tables
l-wilkes:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
l-wilkes:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
SELECT Password FROM mysql.user WHERE User='root';
l-wilkes:~# mysqld_safe --skip-grant-tables&
[1] 5545
l-wilkes:~# Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[5611]: started
l-wilkes:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.32-Debian_7etch10-log Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SELECT Password FROM mysql.user WHERE User='root';
+-------------------------------------------+
| Password |
+-------------------------------------------+
| *DA6A5267784AD518CFC1B69834D7DE87CEB35768 |
| *DA6A5267784AD518CFC1B69834D7DE87CEB35768 |
+-------------------------------------------+
2 rows in set (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.16 sec)
mysql> exit
Bye
l-wilkes:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqldSTOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[7687]: ended
.
[1]+ Done mysqld_safe --skip-grant-tables
l-wilkes:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
l-wilkes:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
l-wilkes:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
UPDATE mysql.user SET Password=PASSWORD('MeinPass') WHERE User='root';
l-wilkes:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
l-wilkes:~# mysqld_safe --skip-grant-tables&
[1] 11559
l-wilkes:~# Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[11607]: started
l-wilkes:~# Enter password
-bash: Enter: command not found
l-wilkes:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.32-Debian_7etch10-log Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> UPDATE mysql.user SET Password=PASSWORD('MeinPass') WHERE User='root';
Query OK, 0 rows affected (0.06 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
Bye
l-wilkes:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqldSTOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[11735]: ended
.
[1]+ Done mysqld_safe --skip-grant-tables
l-wilkes:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
l-wilkes:~# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
l-wilkes:~#
1. mysql stop
2. mysqld_safe --skip-grant-tables&
3. mysql -u root -p
4. mysql> Drop Database mysql;
5. mysql> flush privileges;
6. mysql> exit;
7. mysql stop
8. mysql start
9. mysql_install_db
10. mysql restart
11. mysql_safe -- skip-grant-tables&
12. mysql -u root -p
13. mysql> UPDATE mysql.user SET Password=PASSWORD('MeinPass') WHERE User='root';
14. mysql> flush privileges;
15. mysql> exit;
16. mysql stop
17. mysql start
18. mysql -u root -p
Enter password: [Hier kommt mein Passwort hin]
19. Freuen das alles funktioniert!
We use essential cookies to make this site work, and optional cookies to enhance your experience.