• Discussion

  • default root password mysql for access phpmyadmin

Greetings

I am from Indonesia, thank you for aaPanel to make my VPS settings easier, but I'm confused to find out the mysql root password to access phpmyadmin or other supporting applications because this is my first time hiring a VPS, please help me tell mysql root password thanks.

    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?

          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