ubuntu查看mysql启动没有权限_ubuntu 14.04没有权限登陆mysql

用的服务器,mysql不是自己装,没有权限,也不知道是那个用户,登陆出现下面这种情况

mysql -u root -p

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

比较简单的方法是卸载,重装,不想这样做,想尝试处理,试了很多方法,参考下面这个blog

http://dreamylights.blog.51cto.com/1163218/1324917

cat /etc/mysql/debian.cnf

[client]

host = localhost

user = debian-sys-maint

password = JuSRXfKnBmYWVgTa

socket = /var/run/mysqld/mysqld.sock

[mysql_upgrade]

host = localhost

user = debian-sys-maint

password = JuSRXfKnBmYWVgTa

socket = /var/run/mysqld/mysqld.sock

basedir = /usr

user和password用来登陆mysql,增加一个用户,给权限给这个用户

mysql -udebian-sys-maint -p

Enter password:

mysql> use mysql;

mysql> update user set password=PASSWORD('tianjiewang') where user='tianjiewang';

mysq>grant all privileges on *.* to tianjiwang@localhost identified by 'tianjiewang'; 仅作为自己保存用