[Linux] Fedora20MySQL installation and configuration

In 1MySQL installation and configuration, if yuminstallmysql is directly used in fedora, mariadb is a branch of mysql, which is not much different from mysql. But there is a difference. Maybe it's a branch after all. Mariadb56 is equivalent to mysql version 50 and 51.

MySQL installation and configuration

In fedora, mariadb is a branch of mysql directly installed using yum install mysql, which is not much different from mysql. But there is a difference. Maybe it's a branch after all. Mariadb5.6 feels like mysql 5.0 and 5.1, which I feel from the timestamp. In MySQL, a table does not seem to be able to use two timestamp sub-segments at the same time, or it may be too difficult for me. the same database is no problem in MySQL anyway, if the version is earlier than 5.5, the error message indicating that the timestamp cannot be reused is returned.

If you use yum install mysql, it will be easier to start using systemctl start mysqld. service after installation. The differences between linux versions and linux versions are caused by different directories.

It's far away. To put it bluntly, I used the rpm Package to install mysql for the above reason.

Just install MySQL-client-5.6.15-1.linux_glibc2.5.x86_64.rpm

MySQL-server-5.6.15-1.linux_glibc2.5.x86_64.rpm

These two packages are enough.

Note: you must first install the client and then the server; otherwise, many configurations are required. It took only half a day to complete the installation. Then, after changing the installation sequence, it would be okay.

Sudo rpm-ivh MySQL-client-5.6.15-1.linux_glibc2.5.x86_64.rpm

After sudo rpm-ivh MySQL-server-5.6.15-1.linux_glibc2.5.x86_64.rpm is installed successfully

[Root @ zemo] #/etc/rc. d/init. d/mysql restart

Shutting down MySQL... [OK]

Starting MySQL. [OK]

You can. Then.

[Root @ zemo] # mysql-u root-p

Enter password:

For the first installation, you can run commands without a password:

A ../mysqladmin-u root-p oldpassword newpasswd (remember this command is an external command in/usr/local/mysql/bin)

B. SET PASSWORD FOR root = PASSWORD ('New password'); (this method is used after logging on to the database)

C. UPDATE user SET password = PASSWORD ("new password") WHERE user = 'root'; (this method after logging on to the database) reset the password.

At this point, after successful mysql configuration, Tomcat LAMP and other environment configurations will be added.