https://aznot.com/index.php?action=history&feed=atom&title=MySQL%2FServer 2026-04-29T00:21:00Z Revision history for this page on the wiki MediaWiki 1.41.0 https://aznot.com/index.php?title=MySQL/Server&diff=4333&oldid=prev 2017-05-28T05:31:18Z

<p></p> <p><b>New page</b></p><div>== Installation ==<br /> <br /> sudo yum install mysql-server<br /> sudo /sbin/service mysqld start<br /> # sudo /usr/bin/mysql_secure_installation<br /> <br /> == Security ==<br /> <br /> mysql -u root<br /> use mysql;<br /> truncate user;<br /> truncate db;<br /> grant all on *.* to root@localhost with grant option;<br /> flush privileges;<br /> <br /> If you screw up: [https://stackoverflow.com/questions/1712806/how-to-get-all-privileges-back-to-the-root-user-in-mysql]<br /> /usr/libexec/mysqld --skip-grant<br /> <br /> # in another window:<br /> mysql -u root<br /> use mysql;<br /> truncate user;<br /> truncate db;<br /> describe user; -- match columens<br /> insert into `user` VALUES(&#039;localhost&#039;,&#039;root&#039;,&#039;&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;Y&#039;,&#039;&#039;,&#039;&#039;,&#039;&#039;,&#039;&#039;,0,0,0,0);<br /> # kill and restart mysql</div>

Kenneth