linux°²×°mysql

1¡¢°²×°°ü
ÏÂÔØÍøÖ·£ºhttp://dev.mysql.com/downloads/mysql/
mysql-5.1.38.tar.gz£¨°æ±¾£º5.1.38£©
2¡¢Ìí¼ÓmysqlÓû§ÓëȺ
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
3¡¢½âѹÓë±àÒë
tar zxvf mysql-5.1.38.tar.gz
cd mysql-5.1.38/
./configure --prefix=/usr/local/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=all
make && make install
chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
4¡¢´´½¨MySQLÊý¾Ý¿â´æ·ÅĿ¼¡¢ÒÔmysqlÓû§ÕʺŵÄÉí·Ý½¨Á¢Êý¾Ý±í
mkdir -p /usr/local/mysql/data/
chown -R mysql:mysql /usr/local/mysql
/usr/local/mysql/bin/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
5¡¢my.cnfÅäÖÃÎļþ£¨mysqlÏà¹ØÎĵµ¾ù·ÅÔÚ/usr/local/mysql/share/mysql/£©
cp /usr/local/mysql/share/mysql/my-medium.cnf  /etc/my.cnf
vi /etc/my.cnf
ÔÚ[client]ÏÂÃæÔö¼ÓÒ»ÐÐ:
[client]
default-character-set = utf8
ÔÚ[mysqld]ÏÂÃæÔö¼ÓÈýÐÐ:
[mysqld]
default-character-set = utf8
6¡¢´´½¨¹ÜÀíMySQLÊý¾Ý¿âµÄshell½Å±¾
cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysql
chown root:root /etc/rc.d/init.d/mysql
vi /etc/rc.d/init.d/mysql
# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
7¡¢Æô¶¯MySQL
service mysql start
8¡¢ÐÞ¸Ä mysql µÄ root ÃÜÂ룺
/usr/local/mysql/bin/mysqladmin -u root password 'password'
9¡¢Í¨¹ýÃüÁîÐеǼ¹ÜÀíMySQL·þÎñÆ÷£¨ÌáʾÊäÈëÃÜÂë²¢»Ø³µ£©£º
/usr/local/mysql/bin/mysql -u root -p
10¡¢ÊäÈëÒÔÏÂSQLÓï¾ä£¬´´½¨Ò»¸öÏòÌض¨ip¿ª·ÅµÄÓû§ºÍÃÜÂë
GRANT ALL PRIVILEGES ON *.* TO 'root'@remote-ip IDENTIFIED BY 'password';
11¡¢²âÊÔnavicat:test connection
12¡¢ÐÞ¸ÄmysqlÖеÄuser±íroot@remote-ipµÄGrand-prvΪY
13¡¢ÖØÆômysql
service mysql restart