MySQL 5.5安裝記錄

標籤：

安裝gnake

./configure&& gmake && gmake install

安裝ncurses-devel

yuminstall -y ncurses-devel 

建立使用者和組

groupaddmysql

useraddmysql -s /sbin/nologin -M -g mysql

mysql編譯編譯選項

cmake. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/data/mysql\

-DMYSQL_UNIX_ADDR=/data/tmp/mysql.sock\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci\

-DEXTRA_CHARSETS=all\

-DENABLED_LOCAL_INFILE=ON\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_FEDERATED_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

配置環境變數以及設定檔

cp/usr/local/mysql/support-files/my-small.cnf /etc/my.cnf

echo‘export PATH=/usr/local/mysql/bin:$PATH‘ >> /etc/profile

source/etc/profile

初始化

cd/usr/local/mysql/scripts/

./mysql_install_db–basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql

複製啟動指令碼

/bin/cp/usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

刪除授權表

selectuser,host from mysql.user;

deletefrom mysql.user where user =‘‘;

deletefrom mysql.user where host=‘::1‘;

dropdatabase test;

添加額外管理員

mysql>deletefrom mysql.user;

mysql>grantall privileges on *.* to [email protected]‘localhost‘ identified by ‘123qwe‘with grant option;

mysql>flushprivileges;

selectuser,host from mysql.user;

添加密碼

/usr/local/mysql/bin/mysqladmin-u root password ‘123qwe‘

MySQL 5.5安裝記錄