13.1 Settings Change root password 13.2 Connect MySQL 13.3 mysql common command

13.1 Setting Change root password

[Email protected] init.d]# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
[Email protected] init.d]# path= $PATH:/usr/local/mysql/bin
[Email protected] init.d]# Vim/etc/profile
[Email protected] init.d]# Source/etc/profile
[Email protected] init.d]# Mysql-uroot
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 3
Server version:5.6.35 MySQL Community Server (GPL)
[Email protected] init.d]# mysqladmin-uroot password ' martin.1 '
Warning:using a password on the command line interface can is insecure.
[Email protected] init.d]# Mysql-uroot
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)
[Email protected] init.d]# mysql-uroot-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 6
Server version:5.6.35 MySQL Community Server (GPL)
To know the root password, change the root password:
[Email protected] init.d]# mysqladmin-uroot-p ' martin.1 ' password ' martin.2 '
Warning:using a password on the command line interface can is insecure.

To change the root password without knowing the root password:
Modify/ETC/MY.CNF First line add skip-grant
Restart MySQL service/etc/init.d/mysqld restart
mysql> use MySQL
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a
Database changed
Mysql> SELECT * from user where user= ' root ';
mysql> Update user Set Password=password (' Martinlinux ') where user= ' root ';
Query OK, 4 rows Affected (0.02 sec)
Rows Matched:4 Changed:4 warnings:0

13.2 Connecting MySQL

[Email protected] ~]# mysql-uroot-p ' martinlinux '-h127.0.0.1-p3306
Warning:using a password on the command line interface can is insecure.
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 7
Server version:5.6.35 MySQL Community Server (GPL)
[Email protected] ~]# mysql-uroot-p ' martinlinux '-s/tmp/mysql.sock
Warning:using a password on the command line interface can is insecure.
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 8
[Email protected] ~]# mysql-uroot-p ' martinlinux '-e "show Databases"
Warning:using a password on the command line interface can is insecure.
+--------------------+
| Database |
+--------------------+
| Information_schema |
| MySQL |
| Performance_schema |
| Test |
+--------------------+

13.3 MySQL Common commands

Creating the library create database db1;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db1 |
| mysql |
| performance_schema |
| test |
+--------------------+
5 rows in Set (0.01 sec)
To create table use DB1; creation table T1 ( ID int (4), name Char (40));
mysql> Show create TABLE t1\g;
1. Row
table:t1
Create table:create Table T1 (
ID int (4) DEFAULT NULL,
name char (max) default NULL
) engine=innodb default Charset=utf8
1 row in Set (0.01 sec)

View current database version select version ();
Mysql> select version ();
+-----------+
| Version () |
+-----------+
| 5.6.35 |
+-----------+
1 row in Set (0.00 sec)

View database status Show status;

Mysql> Show status;
+-----------------------------------------------+-------------+
| variable_name | Value |
+-----------------------------------------------+-------------+
| aborted_clients | 0 |
| aborted_connects | 4 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| bytes_received | 1634 |
| bytes_sent | 69469 |

View each parameter show variables; Show variables like ' max_connect% ';
Mysql> Show variables like ' max_connect% ';
+--------------------+-------+
| variable_name | Value |
+--------------------+-------+
| max_connect_errors | 100 |
| max_connections | 151 |
+--------------------+-------+
2 rows in Set (0.00 sec)

Modify parameter set global max_connect_errors=1000;
mysql> Set Global max_connect_errors = 1000;
Query OK, 0 rows affected (0.01 sec)

View queue show Processlist; Show full processlist;
Mysql> show Processlist;
+----+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+-------+------------------+
| 10 | Root | localhost | DB1 | Query | 0 | init | Show Processlist |
+----+------+-----------+------+---------+------+-------+------------------+
1 row in Set (0.01 sec)

Mysql> Show full processlist;
+----+------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+------+---------+------+-------+-----------------------+
| 10 | Root | localhost | DB1 | Query | 0 | init | Show Full Processlist |
+----+------+-----------+------+---------+------+-------+-----------------------+
1 row in Set (0.00 sec)

13.1 Settings Change root password 13.2 Connect MySQL 13.3 mysql common command