New password for the MySQL root user: mysqlsamplepassword. Do not want to use non-secure 'config' authentication. Workaround is to reset root password back to none. BUT cannot connect through phpMyAdmin after setting a root password.
RESETTING PHPMYADMIN ROOT PASSWORD UPDATE
UPDATE user SET PasswordPASSWORD('MYSECRET') WHERE User'root' FLUSH PRIVILEGES exit. No problem changing password and connecting with Terminal or with MySQL Administrator. mysql -u root mysql Change MYSECRET with your new root password. sudo mysqld -skip-grant-tables & Login to MySQL as root. Web server to reconfigure automatically: apache2. Simply change or reset your MySQL root password by doing the following: Stop the MySQL server. MySQL database name for phpmyadmin: phpmyadmin. New password for the MySQL “root” user: mysqlsamplepassword Password of the database’s administrative user: mysqlsamplepassword. Web server to reconfigure automatically: apache2 MySQL database name for phpmyadmin: phpmyadmin Password of the database’s administrative user: mysqlsamplepassword Name of the database’s administrative user: root While searching around I found some step by step instructions on Ask Ubuntu (A Stack Exchange site), by a user named Amigo Chan… They worked a treat Ĭonnection method for MySQL database for phpmyadmin: unix socket I managed to either forget or not configure the root password for the MySQL instance on my Raspberry Pi…
0 kommentar(er)
