Installation of MySQL under Linux

Linux Installation Mysqllinux Networking

IP A View network information

Modify

/etc/sysconfig/network-scripte/ifcfg-eth0

Onboot value of the file, no change to Yes

To restart the Network service:

Service network restart//or compare the original method/etc/init.d/network restart

Yum update appears trying other mirror issues

Yum Clean Metadatayum

Install MySQL

1. Uninstall MySQL First

2. Install MySQL via yum

Update Yum package Yum Check-updateyum update

3. Install MySQL

Yum install-y mysql-server MySQL mysql-devel

4. View MySQL version

Rmp-qi Mysql-server

5. Configure MySQL

1) Start MySQL

Service Mysqld Start|stop|restart|status

　　2) Set Boot start

Chkconfig mysqld on

　　3）First boot set root password

Mysqladmin-u root password ' root '

　　4）Log in to MySQL

Mysql-u root-p

5) Modify the default character set/etc/my.cnf file add

6) Modify default storage engine/etc/my.cnf file add

Default-storage-engine=innodb

　　

Note: The MYSQLD service cannot start the problem after modifying the configuration file

Viewing the log/var/log/mysql.log found a hint:

/usr/bin/mysqld:unknown variable ' Default-character-server=utf8 '

Replacing Character_set_server=utf8 with DEFAULT-CHARACTER-SET=UTF8 can solve the problem.

Installation of MySQL under Linux