Difference between revisions of "MySQL"
(→Topics) |
|||
Line 4: | Line 4: | ||
== Topics == | == 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. | ||
+ | |||
+ | [xxx] | ||
=== Moving the Location of the Data Files === | === Moving the Location of the Data Files === | ||
Line 30: | Line 34: | ||
Reference: [https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/ Configuring MariaDB for Remote Access] | Reference: [https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/ Configuring MariaDB for Remote Access] | ||
− | |||
== Online Resources == | == Online Resources == |
Revision as of 16:24, 7 October 2020
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.
[xxx]
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
Back to Main Page