phpMyadmin root login [SOLVED]
Posted: Sun Feb 26, 2023 8:36 am
I encountered a similar problem in Ubuntu 14.04 using MariaDB. Instead of trying to change everything I just created a new user.
mysql -u root -p
Entered the root password Created a new user using the following command:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
Granted all permissions to newuser:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.
mysql -u root -p
Entered the root password Created a new user using the following command:
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'some_very_complex_password';
Granted all permissions to newuser:
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
You can then log on using newuser in phpMyadmin. I would strongly encourage you to only grant specific privileges to newuser instead of Carte Blanche privileges but it's your own funeral.