ubuntu下在线/离线安装mysql

ゝ一世哀愁。 2022-09-22 04:56 650阅读 0赞

Mysql安装有两种方式一种是在线联网安装，一种是离线安装

1、联网安装：

安装依赖包

sudo apt-get install cmake 
       sudo apt-get install libncurses5-dev

安装mysql

sudo  apt-get install mysql-server
       sudo  apt-get isntall mysql-client
       sudo  apt-get install libmysqlclient-dev

查看是否安装成功:

sudo netstat -tap | grep mysql

通过上述命令检查之后，如果看到有mysql 的socket处于 listen 状态则表示安装成功。

tcp        0      0 localhost:mysql         *:*                     LISTEN      1320/mysqld

登陆mysql数据库

mysql -u root -p

查看mysql版本

mysqladmin -u root -p version

停止mysql:

sudo service mysql stop

启动mysql:

sudo service mysql start

二、离线安装mysql

下载mysql安装包

下载地址：[http://dev.mysql.com/downloads/][http_dev.mysql.com_downloads] 选择相关版本。

我这里下载的是mysql-5.5.50-linux2.6-x86\_64.tar.gz 这个版本

1、解压并移动到/usr/local/mysql

tar -zxvf mysql-5.5.50-linux2.6-x86_64.tar.gz 
       sudo mv mysql-5.5.50-linux2.6-x86_64 /usr/local/mysql

2、添加用户组,赋权限

groupadd mysql
       useradd -r -g mysql mysql
       sudo chown -R mysql:mysql mysql

接着进入mysql目录，修改mysql目录的拥有者,为mysql用户：

cd /usr/local/mysql
       sudo chown -R mysql .
       sudo chgrp -R mysql .

3、安装数据库

/usr/local/mysql$ sudo scripts/mysql_install_db --user=mysql

fulong@FBI003:/usr/local/mysql$ sudo scripts/mysql_install_db --user=mysql
       Installing MySQL system tables...
       160704 16:14:03 [Note] ./bin/mysqld (mysqld 5.5.50) starting as process 7089 ...
       OK
       Filling help tables...
       160704 16:14:03 [Note] ./bin/mysqld (mysqld 5.5.50) starting as process 7095 ...
       OK
       
       To start mysqld at boot time you have to copy
       support-files/mysql.server to the right place for your system
       
       PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
       To do so, start the server, then issue the following commands:
       
       ./bin/mysqladmin -u root password 'new-password'
       ./bin/mysqladmin -u root -h FBI003 password 'new-password'
       
       Alternatively you can run:
       ./bin/mysql_secure_installation
       
       which will also give you the option of removing the test
       databases and anonymous user created by default.  This is
       strongly recommended for production servers.
       
       See the manual for more instructions.
       
       You can start the MySQL daemon with:
       cd . ; ./bin/mysqld_safe &
       
       You can test the MySQL daemon with mysql-test-run.pl
       cd ./mysql-test ; perl mysql-test-run.pl
       
       Please report any problems at http://bugs.mysql.com/

如果有如下报错

Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

则需要安装有一个依赖包

sudo apt-get install libaio-dev

4、启动mysql

sudo ./support-files/mysql.server start

如下错误：

Starting MySQL
       .. * The server quit without updating PID file (/usr/local/mysql/data/FBI003.pid).

看下是否有启动的进程

root@FBI003:/usr/local/mysql# ps -aux|grep mysql
       mysql     5145  0.0  1.1 426928 47160 ?        Ssl  15:44   0:02 /usr/sbin/mysqld
       root      8630  0.0  0.0  11072   680 pts/0    S+   16:50   0:00 grep --color=auto mysq

若有 kill掉，没有的话 考虑是否权限不对

设置mysql用户组权限

chown -R mysql data

5、修改初始密码

./bin/mysqladmin -u root password 'fulong'

6、进入数据库

root@FBI003:/usr/local/mysql/bin# ./mysql -u root -p

7、为了方便期间，可以配置环境变量，直接使用mysql命令

sudo vim /etc/profile
       export MYSQL_HOME=/usr/local/mysql
       export PATH=$MYSQL_HOME/bin:$PATH

source /etc/profile

8、添加mysql自启动

复制到init.d