MySQL數據庫

1）創建mysql用戶的賬號

#?useradd?mysql?-s?/sbin/nologin?–M

建立存放所有安裝軟件的固定目錄

#mkdir?-p?/home/data/tools

2）獲取MySQL軟件包

http://mirrors.sohu.com

3）二進制方式安裝MySQL

#tar?xf?mysql-5.5.49-linux2.6-x86_64.tar.gz#mkdir?-p?/application/#mv?mysql-5.5.49-linux2.6-x86_64?/application/mysql-5.5.49#ln?-s?/application/mysql-5.5.49?/application/mysql

4）初始化MySQL配置問及那my.cnf

#cd/application/mysql#\cp?support-files/my-small.cnf?/etc/my.cnf

5）初始化MySQL數據庫文件

#?mkdir?-p/application/mysql/data/#chown?-Rmysql.mysql?/application/mysql/

#/application/mysql/scripts/mysql_install_db?\ --basedir=/application/mysql?\ --datadir=/application/mysql/data??\ --user=mysql

配置并啟動MySQL數據庫

1）設置MySQL啟動腳本

#?cp?support-files/mysql.server??/etc/init.d/mysqld#?chmod?+x?/etc/init.d/mysqld

2）MySQL二進制默認安裝令是/usr/local/mysql，啟動腳本里是/usr/local/mysql的路徑都需要替換

#?sed?-i's#/usr/local/mysql#/application/mysql#g'?\ /application/mysql/bin/mysqld_safe/etc/init.d/mysqld

3）啟動MySQL數據庫

#?/etc/init.d/mysqld?start

或者使用

#/application/mysql/bin/mysqld_safe?--user=mysql?& <==

4）檢查MySQL數據庫是否啟動

#?netstat?-lntup|grep?mysql

5）查看MySQL數據庫啟動結果日志

#?tail?-10?/application/mysql/data/web01.err

6）設置MySQL開機自啟動

#?chkconfig?--add?mysqld#?chkconfig?mysqld?on#?chkconfig?--list?mysqld

7）配置mysql命令的全局使用路徑

#echo?'export?PATH=/application/mysql/sbin:$PATH'?>>/etc/profile#source?/etc/profile#echo?$PATH /application/mysql/sbin:/usr/local/sbin:/usr/local/bin:/sbin:\ /bin:/usr/sbin:/usr/bin:/root/bin

8）登錄MySQL測試

#mysql?<==直接敲就進入數據庫了，而且身份還是root>show?databases;?<==查看當前所有的數據庫>select?user();?<==查看當前的登錄用戶>quit

MySQL安全配置

1）為MySQL的root用戶設置密碼

#?mysqladmin?-uroot?password?'123456'

2）清理無用的MySQL用戶及庫

>select?user,home?from?mysql,user;>drop?user?"root"@"::1";>drop?user?""@"localhost";>drop?user?"root"@"www";>drop?user?""@"www";>select?user,home?from?mysql,user;>flush?privileges;

轉載于:https://blog.51cto.com/zhanghongxin/1847048

總結

以上是生活随笔為你收集整理的mysql二进制安装的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。