美文网首页
deepin安装mysql密码问题解决方案

deepin安装mysql密码问题解决方案

作者: 慕止 | 来源:发表于2019-01-16 23:30 被阅读0次

    1.安装mysql
    更新仓库:sudo apt-get update
    安装:sudo apt-get install mysql-server mysql-client
    问题:安装mysql5.7的过程中 无root密码设置提示 直接安装完成结束
    2.不知道密码状态下打开mysql
    查询mysql是否运行:sudo netstat -tap |grep mysql
    (有显示就表示已运行)
    备注:
    mysql 打开(service mysql start)
    关闭(service mysql stop)
    重启命令(service mysql restart)
    查询默认的用户名和密码:

            sudo cat /etc/mysql/debian.cnf
            baiguo@baiguo-PC:~$ sudo cat /etc/mysql/debian.cnf 
            # Automatically generated for Debian scripts. DO NOT TOUCH!
            [client]
            host     = localhost
            user     = debian-sys-maint
            password = F64nKZ233QkzL8v9
            socket   = /var/run/mysqld/mysqld.sock
            [mysql_upgrade]
            host     = localhost
            user     = debian-sys-maint
            password = F64nKZ233QkzL8v9
            socket   = /var/run/mysqld/mysqld.sock
    

    备注:这样比较麻烦,无法复制密码,可以直接打开你的文件管理器,用管理员身份打开debian.cnf即可查看复制密码
    利用默认账户进行登录:
    mysql -u debian-sys-maint -p(文件中的密码,与p之间不要有空格)
    3.进入mysql修该密码
    这句必须:update mysql.user set plugin="mysql_native_password" where user="root";
    设置root账户密码:update mysql.user set authentication_string=password('这里是你的密码') where user='root'and Host = 'localhost';
    4.退出数据库
    exit
    重新启动数据库
    sudo service mysql restart
    用自己设置好的密码登录
    mysql -u root -p
    输入密码,成功登录,如下.

            baiguo@baiguo-PC:~$ mysql -u root -p
            Enter password: 
            Welcome to the MySQL monitor.  Commands end with ; or \g.
            Your MySQL connection id is 4
            Server version: 5.7.21-1 (Debian)
    
            Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
            Oracle is a registered trademark of Oracle Corporation and/or its
            affiliates. Other names may be trademarks of their respective
            owners.
    
            Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
            mysql> 
    

    相关文章

      网友评论

          本文标题:deepin安装mysql密码问题解决方案

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