ubuntu安装mysql

ubuntu18安装mysql

安装

sudo apt install mysql-server mysql-client
           

查看

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

           

登陆

使用下面命令登陆后会出现问题

~$ mysql -u debian-sys-maint -p SEo3MwyJl0VNbbe6
Enter password: 
ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

           

问题原因

环境是好的，命令是错误的:)

~$ mysql -udebian-sys-maint -pSEo3MwyJl0VNbbe6 #-u与用户名之间没有空格，-p与密码之间也没有空格
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.35-0ubuntu0.18.04.2 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

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>