MySQL/MariaDB Setup - Revision history

Support at 21:16, 19 May 2017

2017-05-19T21:16:44Z

Support at 21:15, 19 May 2017

2017-05-19T21:15:46Z

Support: Support moved page MySQL/MariaDB to MySQL/MariaDB Setup without leaving a redirect

2017-05-19T21:14:34Z

Support moved page MySQL/MariaDB to MySQL/MariaDB Setup without leaving a redirect

Support: /* mySQL Setup */

2017-05-19T19:47:29Z

‎mySQL Setup

Support: /* mySQL Setup */

2017-05-19T19:45:55Z

‎mySQL Setup

Support: /* Overview */

2017-05-19T19:43:03Z

‎Overview

Support: /* mySQL Setup */

2017-05-19T19:42:20Z

‎mySQL Setup

Support: /* Overview */

2017-05-19T19:20:42Z

‎Overview

Support: Created page with "=== Overview === mySQL is depreciated in favor of the mariaDB replacement in newer OS version (i.e. >=7). mariaDB is the previous mySQL team, but the mySQL name is now owned..."

2017-05-10T04:15:27Z

Created page with "=== Overview === mySQL is depreciated in favor of the mariaDB replacement in newer OS version (i.e. >=7). mariaDB is the previous mySQL team, but the mySQL name is now owned..."

New page

=== Overview ===
mySQL is depreciated in favor of the mariaDB replacement in newer OS version (i.e. >=7). mariaDB is the previous mySQL team, but the mySQL name is now owned by Oracle Corporation (so they had to change it). The server package (yum install) is now mariadb, but the client/command line names are still mysql.

=== mySQL Setup ===

1. install packages
# yum install mysql-server mysql

2. set to start at bootup
# chkconfig mysqld on

3. start mysql server
# service mysqld start

4. secure mysql; setup root password (usually same as OS root pw), disallow root remote access, remove test database
# mysql_secure_installation
OR (see Change Passwords below for issues before running)
# mysqladmin -u root password 'new-password'
# mysql -p mysql
mysql> delete from user where User!='root';
mysql> delete from user where Host!='localhost';
mysql> delete from db;
mysql> drop database test;

5. remove additional/unneeded root acct
# mysql -p
mysql> use mysql;
mysql> delete from user where Host='127.0.0.1';

6. move database directory to the partition that has space (/home)
# service mysqld stop
# cd /var/lib ; mv mysql /home/ ; ln -s /home/mysql
# service mysqld start

=== mySQL Quick Reference ===
*List Databases*
mysql> show databases;

*List Tables*
mysql> show tables;

*Change Passwords*
# mysqladmin -u root password 'new-password'
Note: the mysqladmin command should be run from a shell script, so as to not have this critical password exposed in the command history - make sure to delete the shell script after running

*Delete Database*
mysql> drop database test;

*Creating a new DB and assigning permissions*

Command line/scripted
# mysqladmin -p create wikidb
# echo "grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';" | mysql -p
Note: the echo command should be run from a shell script, so as to not have a critical password exposed in the command history - make sure to delete the shell script after running

mySQL command line - note: this is added to the mysql command history (not a good idea to leave the password exposed):
# mysql -p
mysql> create database wikidb;
mysql> grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';

*Delete From Table*
*Table Structure*
*View Data (Some Query Examples)*

← Older revision		Revision as of 21:16, 19 May 2017
Line 46:		Line 46:
	BEFORE Ent 7		BEFORE Ent 7
	# service mysqld start		# service mysqld start
−
−	~~=== mySQL Quick Reference ===~~
−	~~List Databases~~
−	~~mysql> show databases;~~
−
−	~~List Tables~~
−	~~mysql> show tables;~~
−
−	~~Change Passwords~~
−	~~# mysqladmin -u root password 'new-password'~~
−	~~Note: the mysqladmin command should be run from a shell script, so as to not have this critical password exposed in the command history - make sure to delete the shell script after running~~
−
−	~~Delete Database~~
−	~~mysql> drop database test;~~
−
−	~~Creating a new DB and assigning permissions~~
−
−	~~Command line/scripted~~
−	~~# mysqladmin -p create wikidb~~
−	~~# echo "grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';" \| mysql -p~~
−	~~Note: the echo command should be run from a shell script, so as to not have a critical password exposed in the command history - make sure to delete the shell script after running~~
−
−	~~mySQL command line - note: this is added to the mysql command history (not a good idea to leave the password exposed):~~
−	~~# mysql -p~~
−	~~mysql> create database wikidb;~~
−	~~mysql> grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';~~
−
−	~~Delete From Table~~
−	~~Table Structure~~
−	~~View Data (Some Query Examples)~~

← Older revision		Revision as of 21:15, 19 May 2017
Line 1:		Line 1:
−	~~=== Overview ===~~
−	mySQL is depreciated in favor of the mariaDB replacement in newer OS version (i.e. >=7). mariaDB is created by the previous mySQL team, but the mySQL name is now owned by Oracle Corporation (so they had to change it). The new server package (yum install) is now mariadb, but the client/command line names are still mysql.
−
−	~~=== mySQL Setup ===~~
−
	1. install packages		1. install packages
	ENT 7		ENT 7

@@ Line 38: / Line 38: @@
   mysql> delete from user where Host='127.0.0.1';
-. move database directory
+. move database directory<br>
 a. stop mysql first
   ENT 7

@@ Line 1: / Line 1: @@
 ===  Overview ===
-mySQL is depreciated in favor of the mariaDB replacement in newer OS version (i.e. >=7). mariaDB is created by the previous mySQL team, but the mySQL name is now owned by Oracle Corporation (so they had to change it). The server package (yum install) is now mariadb, but the client/command line names are still mysql.
+mySQL is depreciated in favor of the mariaDB replacement in newer OS version (i.e. >=7). mariaDB is created by the previous mySQL team, but the mySQL name is now owned by Oracle Corporation (so they had to change it). The new server package (yum install) is now mariadb, but the client/command line names are still mysql.
 ===  mySQL Setup ===

← Older revision	Revision as of 21:14, 19 May 2017
(No difference)

@@ Line 22: / Line 22: @@
   # service mysqld start
-. secure mysql; setup root password (sometimes same as OS root pw - NOT A GOOD IDEA!), disallow root remote access, remove test database
+. secure mysql; setup root password, disallow root remote access, remove test database
   # mysql_secure_installation
-  OR (see Change Passwords below for issues before running)
+ answer Y to all of the questions and set root password  (sometimes same as OS root pw - NOT A GOOD IDEA!)
   # mysqladmin -u root password 'new-password'
   # mysql -p mysql

@@ Line 5: / Line 5: @@
 . install packages
   # yum install mysql-server mysql
 . set to start at bootup
   # chkconfig mysqld on
 . start mysql server
   # service mysqld start
-. secure mysql; setup root password (usually same as OS root pw), disallow root remote access, remove test database
+. secure mysql; setup root password (sometimes same as OS root pw - NOT A GOOD IDEA!), disallow root remote access, remove test database
   # mysql_secure_installation
   OR (see Change Passwords below for issues before running)
@@ Line 28: / Line 37: @@
   mysql> delete from user where Host='127.0.0.1';
-. move database directory to the partition that has space (/home)
+. move database directory
   # service mysqld stop
   # cd /var/lib ; mv mysql /home/ ; ln -s /home/mysql
   # service mysqld start