ridhwangs
Hello,
please look here
default root password mysql for access phpmyadmin
Hallo, if i change root password but not change when im login phpmyadmin
ridhwangs
I think you changed the root password when you didn't log out of phpmyadmin. Please re-enter the new root password.
I logged out first, and changed the root passwrod but still can't log in with the root username, I use mysql 8
should this must active?
ridhwangs
No, I have no problem testing on centos7. Can I check it in your panel?
Or you tell me your linux distribution version, I test it
aaPanel_Jose
This my setting:
Platform / OS Package
ubuntu-18.04-x86_64-minimal
Yeah, i hope you can help change root password, where can i give you IP my VPS?
ridhwangs
Please send to zhwyeah@gmail.com
aaPanel_Jose hallo my lord, my panel already fixed after rebuild my vps and change platfrom to centos-7-x86_64-minimal.. thaaanks
ridhwangs
Ok, because these two days are in the exam, there is no time to help you continue to deal with the sorry.
a month later
- Edited
aaPanel_Jose
Hi, my OS Debian 4.9.189-3+deb9u2 (2019-11-11) x86_64 GNU/Linux
i change default MySql root password trough bt tools and give error:
$ bt
choice number 7
[ ok ] Stopping mysqld (via systemctl): mysqld.service.
Changing password...
191207 21:06:01 mysqld_safe Logging to '/www/server/data/customer.worldstream.nl.err'.
191207 21:06:01 mysqld_safe Starting mysqld daemon with databases from /www/server/data
mysql_root.sh: line 17: mysql: command not found
mysql_root.sh: line 20: mysql: command not found
mysql_root.sh: line 21: 15029 Killed mysqld_safe --skip-grant-tables
[ ok ] Starting mysqld (via systemctl): mysqld.service.
===========================================
The root password set GJHKJLghLJKLL successufulMySQL log:
2019-12-07 21:06:10 0 [Note] InnoDB: 10.3.20 started; log sequence number 1630948; transaction id 21
2019-12-07 21:06:10 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2019-12-07 21:06:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-07 21:06:10 0 [Note] Recovering after a crash using mysql-bin
2019-12-07 21:06:10 0 [Note] Starting crash recovery...
2019-12-07 21:06:10 0 [Note] Crash recovery finished.
2019-12-07 21:06:10 0 [Note] InnoDB: Buffer pool(s) load completed at 191207 21:06:10
2019-12-07 21:06:10 0 [Note] Server socket created on IP: '::'.
2019-12-07 21:06:10 0 [Note] Reading of all Master_info entries succeeded
2019-12-07 21:06:10 0 [Note] Added new Master_info '' to hash table
2019-12-07 21:06:10 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.3.20-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2019-12-07 21:08:12 10 [Warning] Access denied for user 'user_host'@'localhost' (using password: YES)
2019-12-07 21:09:59 11 [Warning] Access denied for user 'user_host'@'localhost' (using password: YES)
2019-12-07 21:10:05 12 [Warning] Access denied for user 'user_host'@'localhost' (using password: YES)
2019-12-07 21:10:08 13 [Warning] Access denied for user 'user_host'@'localhost' (using password: YES)
2019-12-07 21:10:10 14 [Warning] Access denied for user 'user_host'@'localhost' (using password: YES)
2019-12-07 21:10:11 15 [Warning] Access denied for user 'user_host'@'localhost' (using password: YES)aaPanel -> Database
send me message "Database password is incorrect"
What am I doing wrong?
- Edited
truepatch SOLVED
https://stackoverflow.com/a/41793945
1) add in config
[mysqld]
skip-grant-tables
2) change password in MySQL maintence
/www/server/mysql/bin/mysql -u root -p
mysql> flush privileges;
mysql> Set new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';3) Restart MySQL service
a year later
ironman
Please check if your mysql service start? or try to change your mysql root password
3 years later
try this.. just set on CLI run mysql -u and next set like command SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
thanks