If you can not connect MediaWiki with your MySQL password and user name, do the following steps.<\/p>\n
sudo \/etc\/init.d\/mysql stop<\/pre>\nOnce MySQL has stopped, run:<\/p>\n
sudo mysqld_safe --skip-grant-tables &<\/pre>\nWhen MariaDB is loaded, run the following command but replace\u00a0username<\/em>\u00a0and\u00a0password<\/em>\u00a0with one of your choosing.<\/p>\n
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';<\/pre>\nOr try to reset the root password:<\/p>\n
sudo \/etc\/init.d\/mysql stop\nsudo mysqld_safe --skip-grant-tables &\nsudo mysql -uroot<\/pre>\nwhen MariaDB is loaded, run the following commands but replace\u00a0newpassword<\/em>\u00a0with the one you want.<\/p>\n
use mysql;<\/pre>\npress enter, then:<\/p>\n
update user set password=PASSWORD(\"newpassword\") where User='root';<\/pre>\npress enter, then:<\/p>\n
flush privileges;<\/pre>\npress enter, then:<\/p>\n
quit\n<\/pre>\npress enter<\/p>\n
Now stop and restart MySQL<\/p>\n
sudo \/etc\/init.d\/mysql stop\nsudo \/etc\/init.d\/mysql start<\/pre>\nTry logging into MySQL<\/p>\n
sudo mysql -u root -p<\/pre>\nAt this point you may have to add a new user if the root password will not work.<\/p>\n
After logging into MySQL, like before, run this command:<\/p>\n
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';<\/pre>\nShare this:<\/h3>