Install mysql5.5.8

ArticleDirectory

• I. Software Packages

I. Software Packages

A) cmake-2.8.3.tar.gz

B) mysql-5.5.8.tar.gz

Ii. Installation Steps

A) tar zxvf cmake-2.8.3.tar.gz

B) CD cmake-2.8.3

C)./Bootstrap

D) Make

E) make install

F) tar zxvf mysql-5.5.8.tar.gz

G) CD mysql-5.5.8

H) configuration parameters

Cmake.-dcmake_install_prefix =/usr/local/mysql5 \

-Dinstall_datadir =/usr/local/mysql5/data \

-Ddefault_charset = utf8 \

-Ddefault_collation = utf8_general_ci \

-Dextra_charsets = all \

-Dwith_ssl = System \

-Dwith_embedded_server = 1 \

-Denabled_local_infile = 1 \

-Dwith_myisam_storage_engine = 1

I) Make

J) make install

K) useradd mysql-D/dev/null-S/sbin/nologin

L) chown-r MYSQL: MySQL/usr/local/mysql5/

M) chown-r MYSQL: MySQL/usr/local/mysql5/Data

N) CP./support-files/my-medium.cnf/etc/My. CNF

O) chown 744./scripts/mysql_install_db

P)./scripts/mysql_install_db-user = mysql-basedir =/usr/local/mysql5-datadir =/usr/local/mysql5/Data

Q) chown-r MYSQL: MySQL/usr/local/mysql5/Data

R)/usr/local/mysql5/bin/mysqld_safe-user = MySQL &

S)/usr/local/mysql5/bin/MySQL-uroot

T) mysql> use MySQL;

U) mysql> Update user SET Password = PASSWORD ('000000') where user = 'root ';

V) CP./support-files/MySQL. Server/etc/init. d/mysql5

W) chkconfig-add mysql5

X) chkconfig mysql5 on

Y) Service mysql5 restart

Iii. Attachment

A) Description of compilation options

Compilation option description:

-Dcmake_install_prefix =/usr/local/mysql5 // installation directory

-Dinstall_datadir =/usr/local/mysql5/Data // database storage directory

-Ddefault_charset = utf8 // use the utf8 character

-Ddefault_collation = utf8_general_ci // check the character

-Dextra_charsets = All // install all extended character sets

-Dwith_ssl = system // use SSL encryption (bundled)

-Dwith_embedded_server = 1 // compile it into the embedded MySQL Library

-Denabled_local_infile = 1 // allow local data import

-Dwith_myisam_storage_engine = 1 // install the MyISAM Engine

B) mysql> show engines;

+ -------------------- + --------- + ------------------------------------------------------------ + ------------ +

| Engine | Support | comment | transactions | XA | savepoints |

+ -------------------- + --------- + ------------------------------------------------------------ + ------------ +

| InnoDB | default | supports transactions, row-level locking, and foreign keys | Yes |

| Performance_schema | Yes | performance schema | no |

| CSV | Yes | CSV storage engine | no |

| Mrg_myisam | Yes | collection of identical MyISAM tables | no |

| MyISAM | Yes | MyISAM storage engine | no |

| Memory | Yes | hash based, stored in memory, useful for temporary tables | no |

+ -------------------- + --------- + ------------------------------------------------------------ + ------------ +

6 rows in SET (0.01 Sec)