【数据库】- MySQ基本安装

CentOS 6.5/6.6 安装(install)mysql 5.7 最完整版教程

Step1: 检测系统是否自带安装mysql

# yum list installed | grep mysql

Step2: 删除系统自带的mysql及其依赖

命令:

# yum -y remove mysql-libs.x86_64

Step3: 给CentOS添加rpm源,并且选择较新的源

命令:

# wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
# yum localinstall mysql-community-release-el6-5.noarch.rpm
# yum repolist all | grep mysql
# yum-config-manager --disable mysql55-community
# yum-config-manager --disable mysql56-community
# yum-config-manager --enable mysql57-community-dmr
# yum repolist enabled | grep mysql

NOTE:这里可以查看要安装的mysql版本,可以启动禁用选择的版本

Step4:安装mysql 服务器

命令:

# yum install mysql-community-server

Step5: 启动mysql 命令:

# service mysqld start

Step6: 查看mysql是否自启动,并且设置开启自启动

命令:

# chkconfig --list | grep mysqld
# chkconfig mysqld on

Step7: mysql安全设置

命令:

# mysql_secure_installation

NOTE: 这里提供对话式的选择配置设置,也可以使用如下命令更改root用户密码 mysqladmin -u root password 'root'

Myql备份与恢复

备份

mysqldump -uroot -p wfchat > wfchat.sql

恢复

mysql -uroot -p db_name < backfile

unbuntu 18.04

Prerequisites

To follow this tutorial, you will need:

One Ubuntu 18.04 server set up by following this initial server setup guide, including a non-root user with sudo privileges and a firewall. Step 1 — Installing MySQL On Ubuntu 18.04, only the latest version of MySQL is included in the APT package repository by default. At the time of writing, that’s MySQL 5.7

To install it, update the package index on your server with apt:

sudo apt update

Then install the default package:

sudo apt install mysql-server

This will install MySQL, but will not prompt you to set a password or make any other configuration changes. Because this leaves your installation of MySQL insecure, we will address this next.

Step 2 — Configuring MySQL

sudo mysql_secure_installation

授权访问

NOTE: root 无法登录时修改密码的解决方案

我们通过apt-get 命令安装的MySQL,默认的登录名和登录密码是保存在 /etc/mysql/debian.cnf 下的

sudo cat /etc/mysql/debian.cnf
  • 使用 debian-sys-maint登录mysql
  • 修改root帐号密码
 use mysql
 update user set authentication_string=password(' 你的密码 ') where user='root' and host='localhost' 
 update user set plugin="mysql_native_password"
 flush privileges
 # 重启mysql
 sudo service mysql restart
  • Check the authentication methods employed by each of your users again to confirm that root no longer authenticates using the auth_socket plugin:
mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

+------------------+-------------------------------------------+-----------------------+-----------+
| user             | authentication_string                     | plugin                | host      |
+------------------+-------------------------------------------+-----------------------+-----------+
| root             | *3636DACC8616D997782ADD0839F92C1571D6D78F | mysql_native_password | localhost |
| mysql.session    | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| mysql.sys        | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| debian-sys-maint | *CC744277A401A7D25BE1CA89AFF17BF607F876FF | mysql_native_password | localhost |
+------------------+-------------------------------------------+-----------------------+-----------+
4 rows in set (0.00 sec)

NOTE: 确认root 帐号plugin 使用的是mysql_native_password,不然root帐号无法使用密码链接mysql, 如果不是可以如下修改

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

参考资料

Search

    Post Directory