• Discussion

  • default root password mysql for access 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?

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

            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 successuful

            MySQL 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?

                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

                    truepatch hello dear boss , I was logged on mysql root user but I m still getting Connection Database failed error on roundcube installation through one click depolyment ?

                      truepatch when i try to install roundcube through oneclick deployment only access website link is showing on oneclick deployment no user and password created on roundcube via oneclick deployment ????

                          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