lamp学习一 mysql源码安装

矫情吗；* 2022-07-15 11:20 198阅读 0赞

1、创建用户和组  
groupadd  mysql  
useradd mysql -g mysql -M -s /sbin/nologin  
id mysql  
cat a.log|bash  
  
  
2、下载mysql软件

http://www.mysql.com

3、编译安装  
\[root@mysql soft\]\# ls  
19-lamp-conf.tar.gz          httpd-2.2.31               mysql-5.1.72.tar.gz  
19期-lamp课上教案201409.txt  httpd-2.2.31.tar.gz        mysql-5.7.9.tar.gz  
apache                       inotify-tools-3.14.tar.gz  php-5.3.27.tar.gz  
cronolog-1.6.2.tar.gz        libiconv-1.14.tar.gz  
解压编译  
./configure \\  
\--prefix=/soft/mysql5.1.72 \\  
\--with-unix-socket-path=/soft/mysql5.1.72/tmp/mysql.sock \\  
\--localstatedir=/soft/mysql5.1.72/data \\  
\--enable-assembler \\  
\--enable-thread-safe-client \\  
\--with-mysqld-user=mysql \\  
\--with-big-tables \\  
\--without-debug \\  
\--with-pthread \\  
\--enable-assembler \\  
\--with-extra-charsets=complex \\  
\--with-readline \\  
\--with-ssl \\  
\--with-embedded-server \\  
\--enable-local-infile \\  
\--with-plugins=partition,innobase \\  
\--with-mysqld-ldflags=-all-static \\  
\--with-client-ldflags=-all-static   
\#--with-plugin-PLUGIN \\  
  
编译MySQL的过程中提示：  
/bin/rm: cannot remove \`libtoolt': No such file or directory  
打开 configure，把 $RM “$cfgfile” 那行删除掉，重新再运行 ./configure 就可以了  
  
make && make install  
echo $?                                      (检查)  
\[root@mysql mysql-5.1.72\]\# echo $?  
0  
\[root@mysql soft\]\# ln -s /soft/mysql5.1.72/ /soft/mysql  
  
  
4、初始化数据库  
\[root@mysql support-files\]\# ll \*.cnf  
\-rw-r--r-- 1 root root  4718 Nov 14 10:59 my-huge.cnf  
\-rw-r--r-- 1 root root 19765 Nov 14 10:59 my-innodb-heavy-4G.cnf  
\-rw-r--r-- 1 root root  4692 Nov 14 10:59 my-large.cnf  
\-rw-r--r-- 1 root root  4703 Nov 14 10:59 my-medium.cnf            
\-rw-r--r-- 1 root root  2471 Nov 14 10:59 my-small.cnf  
实验环境用my-small.cnf就行了  
\[root@mysql support-files\]\# cp my-small.cnf /etc/my.cnf  
\[root@mysql support-files\]\# less /etc/my.cnf  
\# Example MySQL config file for small systems.  
\#  
\# This is for a system with little memory (<= 64M) where MySQL is only used  
\# from time to time and it's important that the mysqld daemon  
\# doesn't use much resources.  
\#  
\# MySQL programs look for option files in a set of  
\# locations which depend on the deployment platform.  
\# You can copy this option file to one of those  
\# locations. For information about these locations, see:  
\# http://dev.mysql.com/doc/mysql/en/option-files.html  
\#  
\# In this file, you can use all long options that a program supports.  
\# If you want to know which options a program supports, run the program  
\# with the "--help" option.  
  
  
\# The following options will be passed to all MySQL clients  
\[client\]  
\#password       = your\_password  
port            = 3306  
socket          = /soft/mysql5.1.72/tmp/mysql.sock  
  
  
\# Here follows entries for some specific programs  
  
  
\# The MySQL server  
\[mysqld\]  
port            = 3306  
socket          = /soft/mysql5.1.72/tmp/mysql.sock  
skip-locking  
key\_buffer\_size = 16K  
max\_allowed\_packet = 1M  
table\_open\_cache = 4  
sort\_buffer\_size = 64K  
read\_buffer\_size = 256K  
read\_rnd\_buffer\_size = 256K  
net\_buffer\_length = 2K  
thread\_stack = 128K  
  
\# Don't listen on a TCP/IP port at all. This can be a security enhancement,  
\# if all processes that need to connect to mysqld run on the same host.  
\# All interaction with mysqld must be made via Unix sockets or named pipes.  
\# Note that using this option without enabling named pipes on Windows  
\# (using the "enable-named-pipe" option) will render mysqld useless!  
\#   
\#skip-networking  
server-id       = 1  
  
\# Uncomment the following if you want to log updates  
\#log-bin=mysql-bin  
  
\# binary logging format - mixed recommended  
\#binlog\_format=mixed  
  
  
\# Uncomment the following if you are using InnoDB tables  
\#innodb\_data\_home\_dir = /soft/mysql5.1.72/data  
\#innodb\_data\_file\_path = ibdata1:10M:autoextend  
\#innodb\_log\_group\_home\_dir = /soft/mysql5.1.72/data  
\# You can set ..\_buffer\_pool\_size up to 50 - 80 %  
\# of RAM but beware of setting memory usage too high  
\#innodb\_buffer\_pool\_size = 16M  
\#innodb\_additional\_mem\_pool\_size = 2M  
\# Set ..\_log\_file\_size to 25 % of buffer pool size  
\#innodb\_log\_file\_size = 5M  
\#innodb\_log\_buffer\_size = 8M  
\#innodb\_flush\_log\_at\_trx\_commit = 1  
\#innodb\_lock\_wait\_timeout = 50  
  
\[mysqldump\]  
quick  
max\_allowed\_packet = 16M  
  
\[mysql\]  
no-auto-rehash  
\# Remove the next comment character if you are not familiar with SQL  
\#safe-updates  
  
  
\[myisamchk\]  
key\_buffer\_size = 8M  
sort\_buffer\_size = 8M  
  
\[mysqlhotcopy\]  
interactive-timeout  
(END)   
  
创建目录   
mkdir -p /soft/mysql5.1.72/tmp/  
mkdir /soft/mysql5.1.72/data  
授权  
\[root@mysql support-files\]\# chown -R mysql.mysql /soft/mysql/  
  
  
初始化数据库（两个ok就可以了）  
\[root@mysql support-files\]\# /soft/mysql/bin/mysql\_install\_db --basedir=/soft/mysql --datadir=/soft/mysql/data/ --user=mysql   
WARNING: The host 'mysql' could not be looked up with resolveip.  
This probably means that your libc libraries are not 100 % compatible  
with this binary MySQL version. The MySQL daemon, mysqld, should work  
normally with the exception that host name resolving will not work.  
This means that you should use IP addresses instead of hostnames  
when specifying MySQL privileges !  
Installing MySQL system tables...  
161114 11:08:03 \[Warning\] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.  
OK  
Filling help tables...  
161114 11:08:03 \[Warning\] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.  
OK  
  
To start mysqld at boot time you have to copy  
support-files/mysql.server to the right place for your system  
  
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !  
To do so, start the server, then issue the following commands:  
  
/soft/mysql/bin/mysqladmin -u root password 'new-password'  
/soft/mysql/bin/mysqladmin -u root -h mysql password 'new-password'  
  
Alternatively you can run:  
/soft/mysql/bin/mysql\_secure\_installation  
  
which will also give you the option of removing the test  
databases and anonymous user created by default.  This is  
strongly recommended for production servers.  
  
See the manual for more instructions.  
  
You can start the MySQL daemon with:  
cd /soft/mysql ; /soft/mysql/bin/mysqld\_safe &  
  
You can test the MySQL daemon with mysql-test-run.pl  
cd /soft/mysql/mysql-test ; perl mysql-test-run.pl  
  
Please report any problems with the /soft/mysql/scripts/mysqlbug script!  
  
\[root@mysql support-files\]\# ll /soft/mysql/data/  
total 8  
drwx------ 2 mysql root 4096 Nov 14 11:08 mysql  
drwx------ 2 mysql root 4096 Nov 14 11:08 test  
查看目录结构（一般删除掉test库）  
\[root@mysql support-files\]\# tree /soft/mysql/data/  
/soft/mysql/data/  
├── mysql  
│?? ├── columns\_priv.frm  
│?? ├── columns\_priv.MYD  
│?? ├── columns\_priv.MYI  
│?? ├── db.frm  
│?? ├── db.MYD  
│?? ├── db.MYI  
│?? ├── event.frm  
│?? ├── event.MYD  
│?? ├── event.MYI  
│?? ├── func.frm  
│?? ├── func.MYD  
│?? ├── func.MYI  
│?? ├── general\_log.CSM  
│?? ├── general\_log.CSV  
│?? ├── general\_log.frm  
│?? ├── help\_category.frm  
│?? ├── help\_category.MYD  
│?? ├── help\_category.MYI  
│?? ├── help\_keyword.frm  
│?? ├── help\_keyword.MYD  
│?? ├── help\_keyword.MYI  
│?? ├── help\_relation.frm  
│?? ├── help\_relation.MYD  
│?? ├── help\_relation.MYI  
│?? ├── help\_topic.frm  
│?? ├── help\_topic.MYD  
│?? ├── help\_topic.MYI  
│?? ├── host.frm  
│?? ├── host.MYD  
│?? ├── host.MYI  
│?? ├── ndb\_binlog\_index.frm  
│?? ├── ndb\_binlog\_index.MYD  
│?? ├── ndb\_binlog\_index.MYI  
│?? ├── plugin.frm  
│?? ├── plugin.MYD  
│?? ├── plugin.MYI  
│?? ├── proc.frm  
│?? ├── proc.MYD  
│?? ├── proc.MYI  
│?? ├── procs\_priv.frm  
│?? ├── procs\_priv.MYD  
│?? ├── procs\_priv.MYI  
│?? ├── servers.frm  
│?? ├── servers.MYD  
│?? ├── servers.MYI  
│?? ├── slow\_log.CSM  
│?? ├── slow\_log.CSV  
│?? ├── slow\_log.frm  
│?? ├── tables\_priv.frm  
│?? ├── tables\_priv.MYD  
│?? ├── tables\_priv.MYI  
│?? ├── time\_zone.frm  
│?? ├── time\_zone\_leap\_second.frm  
│?? ├── time\_zone\_leap\_second.MYD  
│?? ├── time\_zone\_leap\_second.MYI  
│?? ├── time\_zone.MYD  
│?? ├── time\_zone.MYI  
│?? ├── time\_zone\_name.frm  
│?? ├── time\_zone\_name.MYD  
│?? ├── time\_zone\_name.MYI  
│?? ├── time\_zone\_transition.frm  
│?? ├── time\_zone\_transition.MYD  
│?? ├── time\_zone\_transition.MYI  
│?? ├── time\_zone\_transition\_type.frm  
│?? ├── time\_zone\_transition\_type.MYD  
│?? ├── time\_zone\_transition\_type.MYI  
│?? ├── user.frm  
│?? ├── user.MYD  
│?? └── user.MYI  
└── test  
\[root@mysql support-files\]\# cp mysql.server.sh /etc/init.d/mysqld  
\[root@mysql support-files\]\# chkconfig --add mysqld  
\[root@mysql support-files\]\# chkconfig mysqld on  
\[root@mysql support-files\]\# chmod +x /etc/init.d/mysqld  
  
  
启动  
/soft/mysql/bin/mysqld\_safe &  
\[root@mysql support-files\]\# netstat -lntup |grep mysql  
tcp        0      0 0.0.0.0:3306                0.0.0.0:\*                   LISTEN      97864/mysqld   
\[root@mysql support-files\]\# vi /etc/profile  
添加到最后  
PATH="/soft/mysql/bin/:$PATH"  
(生效)  
\[root@mysql support-files\]\# . /etc/profile  
mysql> show databases;  
\+--------------------+  
| Database           |  
\+--------------------+  
| information\_schema |  
| mysql              |  
| test               |  
\+--------------------+  
3 rows in set (0.01 sec)  
  
  
之前mysql不能进去启动方式用/soft/mysql/bin/mysqld\_safe &，有问题   
修改启动文件。  
vi /etc/init.d/mysqld  
写全以下路径即可  
basedir=/soft/mysql/  
datadir=/soft/mysql/data/  
\[root@mysql support-files\]\# /etc/init.d/mysqld start  
/etc/init.d/mysqld: line 270: @HOSTNAME@: command not found  
/etc/init.d/mysqld: line 279: @HOSTNAME@: command not found  
Starting MySQL.                                            \[  OK  \]  
\[root@mysql support-files\]\# lsof -i:3306  
COMMAND   PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME  
mysqld  98207 mysql   10u  IPv4 140526      0t0  TCP \*:mysql (LISTEN)  
  
  
错误解决  
/etc/init.d/mysqld: line 270: @HOSTNAME@: command not found  
/etc/init.d/mysqld: line 279: @HOSTNAME@: command not found  
  
  
mysql调试  
sh -x /etc/init.d/mysqld start  
发现没有生成pid文件  
test -s /soft/mysql/data//mysql.pid  
\[root@mysql support-files\]\# /etc/init.d/mysqld stop  
Shutting down MySQL......161114 11:44:06 mysqld\_safe mysqld from pid file /soft/mysql5.1.72/data/mysql.pid ended  
                                                           \[  OK  \]  
\[2\]-  Done                    /soft/mysql/bin/mysqld\_safe  
\[root@mysql support-files\]\# /etc/init.d/mysqld start  
Starting MySQL.                                            \[  OK  \]  
  
  
启动方法  
/soft/mysql/bin/mysqld\_safe &  
关闭  
mysqladmin shutdown  
  
  
启动方法  
/etc/init.d/mysqld start  
/etc/init.d/mysqld stop  
两种方法不要混用，不然可能有问题  
  
  
5、设置密码  
\[root@mysql support-files\]\# /soft/mysql/bin/mysqladmin -u root password '123'  
\[root@mysql support-files\]\# mysql -uroot -p123  
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 3  
Server version: 5.1.72 Source distribution  
  
  
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.  
  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
mysql> show databases;  
\+--------------------+  
| Database           |  
\+--------------------+  
| information\_schema |  
| mysql              |  
| test               |  
\+--------------------+  
3 rows in set (0.00 sec)  
  
  
mysql> select version();  
\+-----------+  
| version() |  
\+-----------+  
| 5.1.72    |  
\+-----------+  
1 row in set (0.00 sec)  
  
  
mysql> select user();  
\+----------------+  
| user()         |  
\+----------------+  
| root@localhost |  
\+----------------+  
1 row in set (0.00 sec)  
mysql> drop database test;  
Query OK, 0 rows affected (0.03 sec)  
  
  
mysql> show databases;  
\+--------------------+  
| Database           |  
\+--------------------+  
| information\_schema |  
| mysql              |  
\+--------------------+  
2 rows in set (0.00 sec)  
mysql> select user,host from mysql.user;  
\+------+-----------+  
| user | host      |  
\+------+-----------+  
| root | 127.0.0.1 |  
|      | localhost |  
| root | localhost |  
|      | mysql     |  
| root | mysql     |  
\+------+-----------+  
5 rows in set (0.00 sec)  
mysql> select user,host from mysql.user;  
\+------+-----------+  
| user | host      |  
\+------+-----------+  
| root | 127.0.0.1 |  
|      | localhost |  
| root | localhost |  
|      | mysql     |  
| root | mysql     |  
\+------+-----------+  
5 rows in set (0.00 sec)  
  
  
mysql> drop user ""@mysql  
    -> ;  
Query OK, 0 rows affected (0.00 sec)  
  
  
mysql> drop user ""@localhost;  
Query OK, 0 rows affected (0.00 sec)  
  
  
mysql> select user,host from mysql.user;  
\+------+-----------+  
| user | host      |  
\+------+-----------+  
| root | 127.0.0.1 |  
| root | localhost |  
| root | mysql     |  
\+------+-----------+  
3 rows in set (0.00 sec)  
mysql> update mysql.user set host='wolf' where host='mysql' and user='root';  
Query OK, 1 row affected (0.00 sec)  
Rows matched: 1  Changed: 1  Warnings: 0  
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)  
mysql> select user,host from mysql.user;  
\+------+-----------+  
| user | host      |  
\+------+-----------+  
| root | 127.0.0.1 |  
| root | localhost |  
| root | wolf      |  
\+------+-----------+  
3 rows in set (0.00 sec)  
  
  
6、修改密码  
\[root@mysql support-files\]\# /soft/mysql/bin/mysqld\_safe --skip-grant-table &  
\[2\] 100116  
\[root@mysql support-files\]\# 161114 12:02:00 mysqld\_safe Logging to '/soft/mysql5.1.72/data/mysql.err'.  
161114 12:02:00 mysqld\_safe Starting mysqld daemon with databases from /soft/mysql5.1.72/data  
\[root@mysql support-files\]\#   
\[root@mysql support-files\]\#   
\[root@mysql support-files\]\# mysql  
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 1  
Server version: 5.1.72 Source distribution  
  
  
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.  
  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
  
mysql> update mysql.user set password=PASSWORD("123") where host='wolf' and user='root';  
Query OK, 1 row affected (0.00 sec)  
Rows matched: 1  Changed: 1  Warnings: 0  
  
  
mysql> flush privileges;  
Query OK, 0 rows affected (0.00 sec)  
\[root@mysql support-files\]\# pkill -9 mysql  
\[2\]-  Killed                  /soft/mysql/bin/mysqld\_safe --skip-grant-table  
\[root@mysql support-files\]\# mysql  
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/soft/mysql5.1.72/tmp/mysql.sock' (111)  
\[root@mysql support-files\]\# /etc/init.d/mysqld start  
Starting MySQL                                             \[  OK  \]  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
yum install zlib libxml libjpeg freetype libpng gd  curl libiconv  zlib-devel libxml2-devel libjpeg-devel freetype-devel libpng-devel gd-devel curl-devel -y