雞蛋學營運-7：mysql服務安裝配置

標籤：mysql

mysql資料庫二進位安裝-（mysql-172.16.1.6）

1.建立使用者和目錄

useradd mysql -s /sbin/nologin -M

mkdir /application

2.下載解壓

tar xf mysql-5.5.32-linux2.6-x86_64.tar.gz 

mv mysql-5.5.32-linux2.6-x86_64 mysql-5.5.32

ln -s /application/mysql-5.5.32 /application/mysql

chown -R mysql.mysql /application/mysql

3.初始化資料庫

/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

4.組建組態檔案

cp /application/mysql/support-files/my-small.cnf /etc/my.cnf 

cat /application/mysql/bin/mysqld_safe 

5.修改二進位包啟動路徑並在後台啟動mysql

sed -i ‘s#/usr/local/mysql#/application/mysql#g‘ /application/mysql/bin/mysqld_safe 

/application/mysql/bin/mysqld_safe &

6.修改環境變數

echo $PATH

cp /application/mysql/bin/* /usr/local/sbin/

7.登入測試

mysql

exit

8.配置最佳化啟動方式

cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld

sed -i ‘s#/usr/local/mysql#/application/mysql#g‘ /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

killall mysql

lsof -i :3306

killall mysqld

lsof -i :3306

netstat -lntup | grep mysql

/etc/init.d/mysqld start

chkconfig mysqld on

chkconfig --list mysqld

9.設定和修改密碼

mysqladmin -uroot password "oldboy"

mysqladmin -uroot -poldboy password "123456" 

10.有密碼登入命令

mysql -uroot -p123456

mysql -uroot -p

11.mysql簡單操作命令

show databases;

use mysql;

show tablesl

select user,host from mysql.user;

select user();

select database();

drop database databasename;

drop user ‘username‘@‘hostname‘;

本文出自 “有壓力的雞蛋” 部落格，請務必保留此出處http://78124107.blog.51cto.com/5557978/1972006

雞蛋學營運-7：mysql服務安裝配置