![]() Information about the setup is available on this page: 5.3.Instead create another super user, allow all access and then try to connect using that user. Username - root - DB user with right to connect remotely So couple of things, you are trying to grant root access from anywhere.MySQL Server Port - 3306 - the port of the MySQL DB.Use the following yum install command to install MySQL: sudo yum install mysql-server. MySQL Hostname - 127.0.0.1 - db address on the server Once the output indicates that the update and installation are complete, you will be able to install MySQL.sudo mysql ALTER USER 'root''localhost' IDENTIFIED WITH mysqlnativepassword BY 'root' exit Then you should be able to login to Mysql with the normal account. Using the following commands I was able to log in via a normal user. SSH Username - The OS user name of the server that you connect to ERROR 1698 (28000): Access denied for user 'root''localhost' But I was able to login to MySQL via the super user.Choose Connection Method - Standard TCP/IP over SSH. ⢠Passphrase - if the key is secured by pass First make sure your user have a sudo access if not you can use the below command to add your user as sudo user :- sudo adduser sudo The change will take effect the next time the user logs in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |