{"id":2275,"date":"2019-12-12T16:09:31","date_gmt":"2019-12-12T16:09:31","guid":{"rendered":"http:\/\/www.richa1.com\/RichardAlbritton\/?p=2275"},"modified":"2020-02-12T00:59:07","modified_gmt":"2020-02-12T00:59:07","slug":"wireless-nat-server-e-ink-badge-with-apache-php-sql-media-wiki-and-mqtt-2","status":"publish","type":"post","link":"https:\/\/www.richa1.com\/RichardAlbritton\/wireless-nat-server-e-ink-badge-with-apache-php-sql-media-wiki-and-mqtt-2\/","title":{"rendered":"Wireless NAT server E-ink badge with Apache, PHP, SQL, Media Wiki, and MQTT"},"content":{"rendered":"

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>\n
Once MySQL has stopped, run:<\/p>\n
sudo mysqld_safe --skip-grant-tables &<\/pre>\n
When MariaDB is loaded, run the following command but replace username<\/em> and password<\/em> with one of your choosing.<\/p>\n
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';<\/pre>\n
Or try to reset the root password:<\/p>\n
sudo \/etc\/init.d\/mysql stop\nsudo mysqld_safe --skip-grant-tables &\nsudo mysql -uroot<\/pre>\n
when MariaDB is loaded, run the following commands but replace newpassword<\/em> with the one you want.<\/p>\n
use mysql;<\/pre>\n
press enter, then:<\/p>\n
update user set password=PASSWORD(\"newpassword\") where User='root';<\/pre>\n
press enter, then:<\/p>\n
flush privileges;<\/pre>\n
press enter, then:<\/p>\n
quit\n<\/pre>\n
press enter<\/p>\n
Now stop and restart MySQL<\/p>\n
sudo \/etc\/init.d\/mysql stop\nsudo \/etc\/init.d\/mysql start<\/pre>\n
Try logging into MySQL<\/p>\n
sudo mysql -u root -p<\/pre>\n
At 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>\n
Share this:<\/h3>