linux mysql 安裝步驟
1、安裝cmake (可能需要安裝 yum install gcc-c++)
2、安裝yum install ncurses-devel -y
3.創建用戶和組 groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql
4、tar xf mysql-5.5.32.tar.gz
5、進入MySQL目錄,(可能需要 yum install bison)執行
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=ON -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITH_FAST_MUTEXES=1 -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0 -DMYSQL_TCP_PORT=3306
6、make && make install
7、cp mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf
8、添加環境變量 export PATH=/usr/local/mysql/bin:$PATH
9、授權 chown -R mysql.mysql /usr/local/mysql/data/
10、chmod -R 1777 /tmp/
11、在MySQL的安裝目錄下的scripts文件夾下,執行./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql
12、負責MySQL啟動命令 cp support-files/mysql.server /etc/init.d/mysqld
13、授權chmod +x /etc/init.d/mysqld
14、啟動MySQL /etc/init.d/mysqld start
15、查看運行的進程 netstat -lntup|grep 3306
16、刪除無用的用戶和host,select user,host from mysql.user ;
刪除test數據庫
17、刪除root用戶,添加別的數據庫管理員
delete from mysql.user;
grant all privileges on *.* to system@'localhost' identified by 'yjw' with grant option;
/usr/local/mysql//bin/mysqladmin -u root password 'new-password' --設置密碼
/usr/local/mysql//bin/mysqladmin -u root -h bogon password 'root' --修改密碼