Installing MariaDB on Centos 7
Step 1: Add the MariaDB repo to your system. The script below must be run as root. curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash Step 2: Install MariaDB server and client sudo yum install MariaDB-server MariaDB-client -y Step 3: Start the initial MariaDB service sudo systemctl start mariadb.service Step 4: Set the MariaDB service to auto-start […]
MySQL Error: Unknown collation: ‘utf8mb4_unicode_520_ci’
Currently, it seems anyway, a lot of the underlining technologies that I use everyday to build websites (ie, PHP and MySQL) are quickly upgrading and making big changes. These changes are exciting and I look forward to utilizing them as soon as I can but sometimes it is hard to just “flip the switch” on […]
Check MySQL Database for Errors and Repair
When checking the mysql server logs (located at /var/log/mysqld.log) I started seeing errors ending in: …is marked as crashed and should be repaired. You can use (run from server cli): mysqlcheck [database name] to check all of the tables. If one is identified as being in an error state you can repair it using (run […]
MySQL WorkBench 6.0 Issue Logging Into Database Server
Recently I upgraded to Workbench 6.0 and everything was working fine until I tried to log into an old database server that I manage. The interface kept returning the following error: Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)
MySQL user Table Modification
I routinely manipulate the mysql.user table to change host ip addresses of different users. The easiest way for me is to use a simple UPDATE statement that changes all Host=’xxx.xxx.xxx.xxx’ to Host=’yyy.yyy.yyy.yyy’ using this statement: UPDATE user SET Host=’yyy.yyy.yyy.yyy’ WHERE Host=’xxx.xxx.xxx.xxx’; If this is done then the changes will not immediately be reflected in the […]