美文网首页程序员
Ubuntu安装MySql

Ubuntu安装MySql

作者: 北冥摸鱼 | 来源:发表于2022-04-29 15:50 被阅读0次

    su root根据提示输入密码,切换权限
    apt-get install mysql-server -y 安装mysql8
    service mysql start启动mysql
    mysql -V查看版本
    mysql -uroot -p回车登录mysql(第一次不需要密码)

    mysql>use mysql; # 指定数据库mysql
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    

    alter user修改root登录密码

    mysql>alter user root@localhost identified with mysql_native_password by '你的密码';
    

    授权所有ip访问root用户

    mysql>update user set host = '%' where user='root';
    

    授权某一个IP远程登录

    mysql>grant all privileges on *.* to 'root'@'192.168.222.1' with grant option;
    

    授权所有IP远程登录(请勿在正式环境进行此操作)

    grant all privileges on *.* to 'root'@'%' with grant option;
    

    vim /etc/mysql/mysql.conf.d/mysqld.cnf修改mysql配置bind-address允许其他IP访问

     14 [mysqld]
     15 #
     16 # * Basic Settings
     17 #
     18 user            = mysql
     19 # pid-file      = /var/run/mysqld/mysqld.pid
     20 # socket        = /var/run/mysqld/mysqld.sock
     21 # port          = 3306
     22 # datadir       = /var/lib/mysql
     23
     24
     25 # If MySQL is running as a replication slave, this should be
     26 # changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
     27 # tmpdir                = /tmp
     28 #
     29 # Instead of skip-networking the default is now to listen only on
     30 # localhost which is more compatible and is not less secure.
     31 bind-address            = 127.0.0.1 192.168.222.1 #0.0.0.0为所有IP都可访问
     32 mysqlx-bind-address     = 127.0.0.1
     33 #
     34 # * Fine Tuning
     35 #
     36 key_buffer_size         = 16M
    

    相关文章

      网友评论

        本文标题:Ubuntu安装MySql

        本文链接:https://www.haomeiwen.com/subject/cojsyrtx.html