VIKHOST Tech Blog
Useful Technical Articles, Notes and Instructions.
MySQL - Create new user | VIKHOST

MySQL Server-Create New User and Grant Permissions

Create New User and Grant Permissions to MySQL database server In this article, we will explain how to create a new user in MySQL, and grant permissions to that user in MySQL. Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. 1. Log in to MySQL To log in to MySQL system uses the following command: mysql -u root –p By executing this command we tell the MySQL client to log us in with the root user and to prompt us for the user’s password. 2. Creating a new ...
Read more
MySQL - Enable Remote Access | VIKHOST

MySQL Server-Enable Remote Access

Enable remote access to MySQL database server If you try to connect to server mysql from remote server, you will get an error. Initially, mysql uses the standard localhost connection (127.0.0.1). It needs to be fixed this in the configuration file my.cnf (usually in Linux the file is located /etc/mysql/my.cnf) In my.cnf we need to find line: bind-address = 127.0.0.1 It needs to be changed to: bind-address = 0.0.0.0 Now after service mysql restart we can connect to mysql from any IP (if the user is created). At the same time, for the root user, remote access remains under the ...
Read more
Загрузка...