Install MySQL with Yum under Linux, and start, log in, and remotely access the MySQL database.
1. Installation
See if you have installed:
Yum List installed mysql*
Rpm-qa | grep mysql*
To see if there are any installation packages:
Yum List mysql*
To install the MySQL client:
Yum install MySQL
To install the MySQL server side:
Yum Install Mysql-server
Yum Install Mysql-devel
2. Start && Stop
Database Character Set settings
MySQL config file/etc/my.cnf add Default-character-set=utf8
To start the MySQL service:
Service mysqld start or/etc/init.d/mysqld start
Boot start:
Chkconfig-add mysqld, check if boot boot settings are successful chkconfig--list | grep mysql*
Mysqld 0: Off 1: Off 2: Enable 3: Enable 4: Enable 5: Enable 6: Off
Stop it:
Service Mysqld Stop
3. Login
Create root administrator: mysqladmin-u root password 123456
Login: mysql-u root-p Enter the password.
Forgot Password: Service mysqld stop
Mysqld_safe--user=root--skip-grant-tables
Mysql-u Root
Use MySQL
Update user set Password=password ("New_pass") where user= "root";
Flush privileges;
4. Remote Access
Port number for open firewall
MySQL Add permission: The user table in the MySQL library has a new record of "%" and the user is "root".
5. Several important directories of Linux MySQL
Database directory:/var/lib/mysql/
Configuration file:/usr/share/mysql (mysql.server command and configuration file)
Related commands:/usr/bin (mysqladmin mysqldump and other commands)
Startup script:/etc/rc.d/init.d/(startup script file mysql directory)
Install MySQL with Yum under Linux