MySQL – The Picky SysAdmin

Replace MySQL with MiriaDB on CentOS 6

2023-01-022013-02-20 by Eric Schewe

Last modified: [last-modified] I’m running CentOS 6.3 64-bit and have been for a little while. I decided I wanted to swap out MySQL 5.1.x with MiriaDB 5.3.x. Why? Because I can. Plus I’ve read a bit and it sounds like MiriaDB is better optimized than MySQL. Also Oracle is evil. These instructions are based off … Read more

Creating a new user in MySQL from the command line with all permissions

2023-01-022012-03-26 by Eric Schewe

This is purely because I’m lazy and don’t want to Google it every time I need to do it. You’ll need to login via the command line first: mysql -u root -p When prompted enter your root password and you should be logged into a MySQL command line. Run these two commands to create a … Read more