Spyderserve Web Development

Category: MySQL/MariaDB Database Server

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 […]

Spyderserve  2225 Bemiss Road Suite D Valdosta, Georgia 31602 United States