Unzip and install MySQL in Ubuntu

Unzip MySQL in Ubuntu and install Ubuntu

1. unzip the package to/usr/local/mysql in Ubuntu.
Groupadd mysql
Useradd-g mysql
Cd/usr/local/mysql
Chown-R mysql.
Chgrp-R mysql.
Chown-R root.
Chown-R mysql data
Cp/usr/local/mysql/support-files/mysql. server/etc/init. d/mysqld
Cp/usr/local/mysql/support-files/my-huge.cnf/etc/my. cnf

2. modify my. cnf
Nano/etc/my. cnf
Add
Basedir =/usr/local/mysql
Datadir =/home/mysql

3. initialize the database
Scripts/mysql_install_db -- user = mysql

4. start
Bin/mysqld_safe -- user = mysql &
Change password
Mysql> use mysql
Mysql> UPDATE user SET password = PASSWORD ('root') WHERE user = 'root ';
Mysql> flush privileges;
Mysql> exit

5. set automatic startup
Apt-get install chkconfig
Chkconfig -- add mysqld
Chkconfig mysqld on

6. add mysql to path
Nano/etc/profile
Add this sentence before umask
Export PATH = $ PATH:/usr/local/mysql/bin

7. restart the system
Reboot