SBN - Database Server Notes - Revision history

Tinker: /* Reference Materials */

2023-02-05T05:29:24Z

Reference Materials

Tinker: /* Reference Materials */

2023-02-05T05:22:23Z

Reference Materials

Tinker at 18:37, 1 December 2020

2020-12-01T18:37:51Z

Tinker: /* Move a database from one server to another */

2020-07-23T20:55:22Z

Move a database from one server to another

Tinker: /* Useful Things */

2020-07-22T21:18:36Z

Useful Things

Tinker: /* Useful Things */

2020-07-22T21:11:40Z

Useful Things

Tinker: /* NON LOCALHOST ACCESS! */

2020-07-22T21:06:32Z

NON LOCALHOST ACCESS!

Tinker: /* NON LOCALHOST ACCESS! */

2020-07-22T21:03:17Z

NON LOCALHOST ACCESS!

Tinker: /* Set up at least one user in mysql */

2020-07-22T20:14:16Z

Set up at least one user in mysql

Tinker: /* Linux Mint */

2020-07-18T21:44:44Z

Linux Mint

@@ Line 61: / Line 61: @@
 ==Reference Materials==
 *[http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm Commands]
 *[https://www.freecodecamp.org/news/basic-sql-commands/ Basic SQL Commands - The List of Database Queries and Statements You Should Know]

@@ Line 62: / Line 62: @@
 *[http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm Commands]
 *[https://linuxize.com/post/how-to-manage-mysql-databases-and-users-from-the-command-line/ How to Manage MySQL Databases and Users from the Command Line]
 *[https://www.hostinger.com/tutorials/?s=mysql Some handy tutorials]

@@ Line 1: / Line 1: @@
 A dedicated server Just to run MySQL...
 Then you can simply point all the other things that use it to a central location.
@@ Line 83: / Line 85: @@
 ===Move a database from one server to another===
-==== On the originating server: ====
+====On the originating server:====
-* <code>sudo mysql -u root -p</code>
+*<code>sudo mysql -u root -p</code>
-** <code>GRANT ALL ON *.* TO 'user'@'localhost';</code>
+**<code>GRANT ALL ON *.* TO 'user'@'localhost';</code>
-** <code>FLUSH PRIVILEGES;</code>
+**<code>FLUSH PRIVILEGES;</code>
-** <code>EXIT;</code>
+**<code>EXIT;</code>
-* <code>mysqldump -u user -p DBname > DBname.sql</code>
+*<code>mysqldump -u user -p DBname > DBname.sql</code>
-* <code>scp DBname.sql user@Machine.Domain.TLD:~</code>
+*<code>scp DBname.sql user@Machine.Domain.TLD:~</code>
-==== On the destination server: ====
+====On the destination server:====
 Create the user & database (following the instructions for the application requiring the database)
-* <code>mysql -u user -p DBname < DBname.sql</code>
+*<code>mysql -u user -p DBname < DBname.sql</code>
-==== If using a separate DB Server... ====
+====If using a separate DB Server...====
 Create the user & database on the DB Server, then log onto the application server &do the following
 (You may have to backtrack & SCP the file to the application server...  :P )
-* <code>mysql -u user -p -h Machine.Domain.TLD DBname < DBname.sql</code>
+*<code>mysql -u user -p -h Machine.Domain.TLD DBname < DBname.sql</code>

@@ Line 81: / Line 81: @@
 **<code>SELECT user,host FROM mysql.user;</code>
-=== Move a database from one server to another ===
+===Move a database from one server to another===
-Coming<sup>TM</sup> Soon<sup>TM</sup>

@@ Line 66: / Line 66: @@
 ==Useful Things==
 *Restart MySQL
 **<code>sudo systemctl restart mysql.service</code>
@@ Line 78: / Line 80: @@
 *List existing users
 **<code>SELECT user,host FROM mysql.user;</code>

@@ Line 70: / Line 70: @@
 *Change a user password
 **<code>ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';</code>
 *Trash a complete database '''(WARNING! DANGER! DAMAGE LIKELY!)'''
 **<code>DROP DATABASE wp_Someblog;</code>

@@ Line 35: / Line 35: @@
 This is ugly, but works for now:
-* <code>sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf</code>
+*<code>sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf</code>
 & change
@@ Line 43: / Line 43: @@
 to
-<code>bind-address              = '''Actual IP Address'''</code>
+<code>bind-address              = '''Machine.Domain.TLD'''</code>
 ==Set up at least one user in mysql==

@@ Line 5: / Line 5: @@
 i.e.: Wikipedia, WordPress, WeeWX, etc...
-== Installation ==
+==Installation==
 ===Linux Mint===
@@ Line 30: / Line 30: @@
 **(pretty much same as [[MySQL - Initial Configuration]] except the root password is already done...)
-== NON LOCALHOST ACCESS! ==
+==NON LOCALHOST ACCESS!==
 ==Set up at least one user in mysql==

@@ Line 5: / Line 5: @@
 i.e.: Wikipedia, WordPress, WeeWX, etc...
-= Linux Mint =
+=Linux Mint=
-* <code>sudo apt install mysql-server mysql-client php-mysql</code>
+*Mint 19.3 Seems to get MySQL 5.7.30
-** Say Yes to Continue
+*Mint 20 Gets MySQL 8.0.20
-= SparkyLinux =
+*<code>sudo apt install mysql-server mysql-client php-mysql</code>
-* Doesn't even have MySQL in the repositories...
+**Say Yes to Continue
-* [[TinkerWiki:Getting MySQL onto SparkyLinux]]
+*See [[MySQL - Initial Configuration]] for configuration
-* <code>sudo apt install mysql-server mysql-client php-mysql</code>
+=SparkyLinux=
-= Set up at least one user in mysql =
+*Doesn't even have MySQL in the repositories...
-* <code>sudo mysql -u root -p</code>
+*<code>sudo apt install mysql-server mysql-client php-mysql</code>
-** You will be asked for '''2''' passwords, your own & that of the root database user.
+**Say Yes to Continue
   CREATE USER 'someone'@'localhost' IDENTIFIED BY 'password';
@@ Line 36: / Line 38: @@
 ('''Hint:'''  This'd be a good time to create yourself as that user with your non-admin password of choice...)
-If this is to be a remotely accessed Database Server, ''''localhost'''' will actually be the name/address of the remote machine you'll access '''from'''. (Possibly even ''''*'''')
+If this is to be a remotely accessed Database Server, '<nowiki/>'''localhost'<nowiki/>''' will actually be the name/address of the remote machine you'll access '''from'''. (Possibly even '<nowiki/>'''*'''')
-= Reference Materials =
+=Reference Materials=
-* [http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm Commands]
+*[http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm Commands]
-* [https://linuxize.com/post/how-to-manage-mysql-databases-and-users-from-the-command-line/ How to Manage MySQL Databases and Users from the Command Line]
+*[https://linuxize.com/post/how-to-manage-mysql-databases-and-users-from-the-command-line/ How to Manage MySQL Databases and Users from the Command Line]
-* [https://www.hostinger.com/tutorials/?s=mysql Some handy tutorials]
+*[https://www.hostinger.com/tutorials/?s=mysql Some handy tutorials]
-** [https://www.hostinger.com/tutorials/mysql-show-users/ How to Show Users in MySQL on Linux]
+**[https://www.hostinger.com/tutorials/mysql-show-users/ How to Show Users in MySQL on Linux]
-= Useful Things =
+=Useful Things=
-* Restart MySQL
+*Restart MySQL
-** <code>sudo systemctl restart mysql.service</code>
+**<code>sudo systemctl restart mysql.service</code>
-* Change a user password
+*Change a user password
-** <code>ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';</code>
+**<code>ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';</code>
-* Trash a complete database '''(WARNING! DANGER! DAMAGE LIKELY!)'''
+*Trash a complete database '''(WARNING! DANGER! DAMAGE LIKELY!)'''
-** <code>DROP DATABASE wp_Someblog;</code>
+**<code>DROP DATABASE wp_Someblog;</code>
-* List existing databases
+*List existing databases
-** <code>SHOW databases;</code>
+**<code>SHOW databases;</code>
-* List existing users
+*List existing users
-** <code>SELECT user,host FROM mysql.user;</code>
+**<code>SELECT user,host FROM mysql.user;</code>