Mysql编译安装详解

wget http://mirrors.cnnic.cn/apache/httpd/mysql-5.5.20.tar.gz

root@Mysql-server ~]# yum install -y cmake ncurses-devel

[root@Mysql-server ~]# tar zxvf mysql-5.5.20.tar.gz -C /usr/src/

[root@Mysql-server ~]# cd /usr/src/mysql-5.5.20/
[root@Mysql-server mysql-5.5.20]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc/ -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

root@Mysql-server mysql-5.5.20]# make

[root@Mysql-server mysql-5.5.20]# make install 

[root@Mysql-server mysql-5.5.20]# useradd -M -s /sbin/nologin mysql
[root@Mysql-server mysql-5.5.20]# chown mysql:mysql /usr/local/mysql/
[root@Mysql-server mysql-5.5.20]# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

[root@Mysql-server mysql-5.5.20]# echo "PATH=$PATH:/usr/local/mysql/bin:" >> /etc/profile
[root@Mysql-server mysql-5.5.20]# source /etc/profile

[root@Mysql-server mysql-5.5.20]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@Mysql-server mysql-5.5.20]# chmod +x /etc/init.d/mysqld

[root@Mysql-server mysql-5.5.20]# chkconfig --add mysqld

[root@Mysql-server mysql-5.5.20]# chkconfig mysqld on 

[root@Mysql-server mysql-5.5.20]# /etc/init.d/mysqld start
Starting MySQL......... SUCCESS!
[root@Mysql-server mysql-5.5.20]# mysqladmin -u root password '123.com'

mysql> create database xiaoyudb;

mysql> use xiaoyudb;

mysql> mysql> create table test01 (id varchar(20),name varchar(20));

mysql> insert into test01 values("001","xiaoyu");
Query OK, 1 row affected (0.19 sec)

mysql> select * from test01;
+------+--------+
| id | name |
+------+--------+
| 001 | xiaoyu |
+------+--------+
1 row in set (0.01 sec)

mysql> create table test02 (id varchar(20),name varchar(20));
Query OK, 0 rows affected (1.00 sec)

mysql> insert into test02 values("002","zhangsan");     #在表中插入数据
Query OK, 1 row affected (0.61 sec)

mysql> desc test01;       # 查看表结构字段内容
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | varchar(20) | YES | | NULL | |
| name | varchar(20) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> alter table test01 modify column name varchar(30);     #修改表中name字段的长度
Query OK, 1 row affected (0.05 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> update test01 set name='hexun.net' where id =1;  update test01 set name='hexun.net'；   #修改表中某字段中的数据      
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from test01;      #查看表中数据是否变动！
+------+-----------+
| id | name |
+------+-----------+
| 001 | hexun.net |
+------+-----------+
1 row in set (0.00 sec)

mysql> grant all on xiaoyudb.* to test@localhost identified by '123.com';      
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update,delete on *.* to test@"%" identified by '123.com';  
Query OK, 0 rows affected (0.00 sec）

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

[root@Mysql-server mysql-5.5.20]# cd /usr/local/mysql/data/

[root@Mysql-server data]# mysqldump -uroot -p123.com xiaoyudb > /tmp/testyudb.sql

• 修改Mysql字符集为UTF-8的方法：

在/etc/my.cnf对应如下配置段加入相应命令。

[client]字段里加入  default-character-set=utf8

[mysqld]字段里加入character-set-server=utf8

[mysql]字段里加入  default-character-set=utf8

mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

[root@Mysql-server tmp]# /usr/local/mysql/bin/mysqld_safe --user=mysql --skip-grant-tables &
[1] 11893
[root@Mysql-server tmp]# 170908 09:30:31 mysqld_safe Logging to '/usr/local/mysql/data/Mysql-server.err'.
170908 09:30:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

[root@Mysql-server tmp]# mysql

mysql> update user set password=password('123456') where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

启动mysql，输入已修改好的密码，重新登录即可

[root@Mysql-server tmp]# mysql -u root -p123456