In this blog, would like to add steps to MySQL
- Installation
- Configuration
- Creating Database
- Creating User
- Logging into mysql using newly created user
Installation
1. Install below mysql packages on the node.
[root@VM200 ~]# rpm -qa| grep mysql
mysql-5.1.73-8.el6_8.x86_64
mysql-connector-java-5.1.17-6.el6.noarch
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-devel-5.1.73-8.el6_8.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
#yum install mysql mysql-connector-java mysql-devel mysql-server -y
Configuration
2. Check the mysql services is runing or not using below command.
[root@VM200 ~]# service mysqld status
mysqld is stopped
Start the mysql service.
[root@VM200 ~]#
service mysqld start
Or inst
All packages are available in below location:
https://dev.mysql.com/downloads/mysql/5.6.html#downloads
[root@psnode142 mapr]#
rpm -Uvh mysql-community-release-el7-5.noarch.rpm[root@psnode142 mapr]#
yum install mysql-server[root@psnode142 mapr]#
service mysqld statusRedirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Community Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2018-02-27 09:12:20 PST; 2s ago
[root@psnode142 mapr]#
netstat -plant| grep 3306tcp6 0 0 :::3306 :::* LISTEN 19006/mysqld
[root@psnode142 mapr]#
3. Run the secure installation by providing the root password of underlying OS and generate new password for mysql logging in.
[root@VM200 ~]#
/usr/bin/mysql_secure_installation
Enter current password for root (enter for none): (linux VM PWD: yy)
Change the root password? [Y/n] y
New password: (MySQL root PWD: x)
Re-enter new password: (x)
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] n
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y
Creating Database & User
4. Logging into MySQL
[root@tVM200 mapr]#
mysql -u root -p
Enter password: <mapr>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.6.39 MySQL Community Server (GPL)
mysql>
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
mysql>
create database sdb;
Query OK, 1 row affected (0.00 sec)
mysql>
grant all on sdb.* to 'suser'@'%' identified by 'mapr';
Query OK, 0 rows affected (0.00 sec)
mysql>
flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
exit
Bye
[root@VM200 mapr]#
mysql -u suser -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.6.39 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| sdb |
+--------------------+
2 rows in set (0.00 sec)
mysql>
use sdb;
Database changed
mysql>
show tables;
Empty set (0.00 sec)
