Thay đổi Pasword SQL VPS Linux Jx

[phjthjenngoa]

Mấy bác cho e hỏi e muốn đổi password SQL trên Linux.

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

service mysql stop
sudo mysqld_safe --skip grant-tables &
này nó báo như sau.

[root@localhost ~]# service mysql stop
Redirecting to /bin/systemctl stop mysql.service
[root@localhost ~]# sudo mysqld_safe --skip grant-tables &
[1] 31221
[root@localhost ~]# 200107 23:29:52 mysqld_safe Logging to '/var/log/mysqld.log'.
200107 23:29:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200107 23:29:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
mysql -u - root
mysql: Unknown OS character set 'GB18030'.
mysql: Switching to the default character set 'latin1'.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Có bác nào setup nhìu giúp e đây là lỗi gì ạ.

[cuongvh93]

Mấy bác cho e hỏi e muốn đổi password SQL trên Linux.

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

service mysql stop
sudo mysqld_safe --skip grant-tables &
này nó báo như sau.

[root@localhost ~]# service mysql stop
Redirecting to /bin/systemctl stop mysql.service
[root@localhost ~]# sudo mysqld_safe --skip grant-tables &
[1] 31221
[root@localhost ~]# 200107 23:29:52 mysqld_safe Logging to '/var/log/mysqld.log'.
200107 23:29:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200107 23:29:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
mysql -u - root
mysql: Unknown OS character set 'GB18030'.
mysql: Switching to the default character set 'latin1'.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Có bác nào setup nhìu giúp e đây là lỗi gì ạ.

mysql đó hả?.........................................