CentOS MySQL Combat seventh session

CentOS MySQL Combat seventh session

MySQL Common error troubleshooting

1. Client Tools
Mysql
SQLyog
Mysqldump (Mysqlbinlog)

2. mysql Binlog introduction

MySQL command

Mysql
Command not Found
Environment variables
Echo $PATH

Using an absolute path to invoke
/usr/local/mysql/bin/mysql

===============================================
Ah Ming
Removing environment variables
\CP =/BIN/CP
\CP 2.txt eee/
# CD eee/
# LL
Total 4
-rw-r--r--1 root root 223 Apr 20:40 2.txt

MySQL prompt
prompt = ' (product) \[email protected]\h [\d]> '
Prompt modification takes effect
1, whether to read the correct my.cnf
My.cnf
2. Do you want to put it in [MySQL] section?
[Client]
[mysql],prompt = to be placed in [MySQL]

About MY.CNF
mysqld [Mysqld]
mysql [client] [MySQL] means [client]>[mysql]
MySQL is the client, mysqld is the server, client includes MySQL clients, also contains similar to mysqldump and Mysqlbinlog.
Mysqldump and Mysqlbinlog can only read the [Client] section

Wu Bingxi (82565387) 20:50:14
Two methods of executing MySQL command in shell
1, mysql-e "SQL"
2, echo "Select User from XX" |mysql
Cannot print out the execution time and warning

Three yards in Unity
\s
Server Characterset:utf8
Db Characterset:utf8
Client Characterset:utf8
Conn. Characterset:utf8

Wu Bingxi (82565387) 20:56:56
SQLyog
PhpMyAdmin
Navicat
MySQL Workbench

I only recommend two: SQLyog, MySQL Workbench

F

CentOS MySQL Combat seventh session