MySQL

From aoxoaWiki
Jump to navigationJump to search

Even though MySQL is now an Oracle product, it still retains an open source component. In some ways, this is a good thing - we can develop a system using the open source version, and if a client wishes to upgrade to a paid, fully supported commercial product, the option is there.

Note that MySQL development has forked. Oracle continues to develop and maintain MySQL. The original developers of MySQL have forked off MariaDB. At present the two are compatible and almost interchangeable.

Topics

I added a page about installing MariaDB on Ubuntu 18.04 as part of the Bugzilla installation process. It has some more up-to-date installation notes.

Installing Bugzilla

Moving the Location of the Data Files

MySQL puts its database files in /var/lib/mysql. The easiest way to move those files to a larger partition is to simply create a link from /var/lib/mysql to the new location.

  ln -s /home/mysql /var/lib/mysql

The big thing to remember here is that if you recreate the server, you have to put the symbolic link back in.

Remote Access

This has been tested with MariaDB. It should be similar to MySQL, but...

Test whether the installation itself allows for remote access. From the server that MariaDB/MySQL is installed on:

LocalHost should always work (you will need to enter the password):

  mysql --host=localhost --protocol=tcp --port=3306 -u root -p

If access from a different server is not allowed, this will fail (use the IP address/name of the sever you are on - ie:same IP as localhost but don't use 127.0.0.1):

  mysql --host=192.168.1.34 --protocol=tcp --port=3306 -u root -p
  ERROR 1130 (HY000): Host '192.168.1.34' is not allowed to connect to this MariaDB server

Reference: Configuring MariaDB for Remote Access

Online Resources

www.mysql.com

mariadb.org



Back to Main Page