VIKHOST Tech Blog
Useful Technical Articles, Notes and Instructions.
Create a New User and Grant Permissions in MySQL

Create a New User and Grant Permissions in MySQL

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 …

/ MySQL
MySQL Server-Enable Remote Access

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 …

/ MySQL

Loading...