MySQL Common operations

MySQL Common operations

• Set Change root password
• Connect to MySQL
• MySQL Common commands
• MySQL User management
• Common SQL statements
• MySQL Database backup recovery

Set Change root password

By default, the root user password for MySQL is empty and can be logged in directly. For security, set the root password.

/usr/local/mysql/bin/mysql -uroot  //直接进入mysql

export PATH=$PATH:/usr/local/mysql/bin/   //临时加入到PATH所指定的路径中

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile  //重启永久生效

MySQL Common operations