☆ 安装 MySQL
cat /etc/redhat-release
uname -m
cd /root/tools
tar zxvf cmake-2.8.12.tar.gz
cd cmake-2.8.12
./configure
gmake
gmake install
cd ..
yum install ncurses -y
yum install ncurses-devel -y
rpm -qa ncurses
rpm -qa ncurses-devel
groupadd mysql
useradd mysql -g mysql -M -s /sbin/lologin
-M 不创建家目录 -s /sbin/lologin 不让登陆
id mysql
tar -zxvf mysql-5.5.60.tar.gz
cd mysql-5.5.60
mkdir -p /application/mysql-5.5.60/data
mkdir -p /application/mysql-5.5.60/tmp/
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.60 \
-DMYSQL_DATADIR=/application/mysql-5.5.60/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.60/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_FEDERATED_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
make
make install
echo 'export PATH=/application/mysql-5.5.60/bin:$PATH' >>/etc/profile
tail -5 /etc/profile
source /etc/profile
echo $PATH
cp support-files/my-small.cnf /etc/my.cnf
chown -R mysql.mysql /application/mysql-5.5.60/data/
chown -R mysql.mysql /application/mysql-5.5.60/tmp/
chown -R 1777 /tmp/
./mysql_install_db --basedir=/application/mysql-5.5.60 --datadir=/application/mysql-5.5.60/data --user=mysql
cp /root/tools/mysql-5.5.60/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
/etc/init.d/mysqld start
netstat -lntup | grep 3306
mysql
select user, host from mysql.user;
delete from mysql.user where user='';
select user, host from mysql.user;
delete from mysql.user where host='localhost.localdomain';
# localhost.localdomain 是 Linux 主机名字。
select user, host from mysql.user;
delete from mysql.user where host='::1';
select user, host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
+------+-----------+
2 rows in set (0.00 sec)
show databases;
drop database test;
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
quit
/application/mysql-5.5.60/bin/mysqladmin -u root password 'sentroot';
mysql -uroot -p
quit
chkconfig mysqld on
cat /etc/redhat-release
uname -m
cd /root/tools
tar zxvf cmake-2.8.12.tar.gz
cd cmake-2.8.12
./configure
gmake
gmake install
cd ..
yum install ncurses -y
yum install ncurses-devel -y
rpm -qa ncurses
rpm -qa ncurses-devel
groupadd mysql
useradd mysql -g mysql -M -s /sbin/lologin
-M 不创建家目录 -s /sbin/lologin 不让登陆
id mysql
tar -zxvf mysql-5.5.60.tar.gz
cd mysql-5.5.60
mkdir -p /application/mysql-5.5.60/data
mkdir -p /application/mysql-5.5.60/tmp/
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.60 \
-DMYSQL_DATADIR=/application/mysql-5.5.60/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.60/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_FEDERATED_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
make
make install
echo 'export PATH=/application/mysql-5.5.60/bin:$PATH' >>/etc/profile
tail -5 /etc/profile
source /etc/profile
echo $PATH
cp support-files/my-small.cnf /etc/my.cnf
chown -R mysql.mysql /application/mysql-5.5.60/data/
chown -R mysql.mysql /application/mysql-5.5.60/tmp/
chown -R 1777 /tmp/
./mysql_install_db --basedir=/application/mysql-5.5.60 --datadir=/application/mysql-5.5.60/data --user=mysql
cp /root/tools/mysql-5.5.60/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
/etc/init.d/mysqld start
netstat -lntup | grep 3306
mysql
select user, host from mysql.user;
delete from mysql.user where user='';
select user, host from mysql.user;
delete from mysql.user where host='localhost.localdomain';
# localhost.localdomain 是 Linux 主机名字。
select user, host from mysql.user;
delete from mysql.user where host='::1';
select user, host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
+------+-----------+
2 rows in set (0.00 sec)
show databases;
drop database test;
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
quit
/application/mysql-5.5.60/bin/mysqladmin -u root password 'sentroot';
mysql -uroot -p
quit
chkconfig mysqld on
chkconfig --list mysqld
☆ 查看 MySQL 基本安装信息
ps -ef|grep mysql
--basedir=/usr/local/mysql
--datadir=/var/lib/mysql
--user=mysql
--log-error=/var/log/mysqld.log
--pid-file=/var/lib/mysql/SeNT.pid
--socket=/var/lib/mysql/mysql.sock
--port=3306
启动命令 /usr/local/mysql/bin/mysqld