Bootstrap FreeKB - mySQL / MariaDB - Migrate a database from SQL Server to MySQL
mySQL / MariaDB - Migrate a database from SQL Server to MySQL

Updated:   |  mySQL / MariaDB articles

On the MySQL server, type mysql -u root -p and press enter to connect to MariaDB. Type the password entered during the mysql_secure_installation.

[root@server1 ~]# mysql -u root -p
Enter password:

 

Use the following command to view the current users. In this example, there are 3 user accounts for root, and root can only connect from the localhost. 

MariaDB [(none)]> select user,host from mysql.user;
+------------------+
| user | host      |
+------------------+
| root | 127.0.0.1 |
| root | ::1       |
| root | localhost |
+------------------+
3 rows in set (0.00 sec)

 

Type create user 'temp'@'%' identified by 'password'; to give temp permission to connect from any PC in the subnet.

MariaDB [(none)]> create user 'temp'@'%' identified by 'Password123';
Query OK, 0 rows affected (0.00 sec)

 

Give tempall permissions.

MariaDB [(none)]> grant all on *.* to 'temp'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)

 

Open port 3306 on the MySQL server.

On the client PC, download and install MySQL Workbench. 

In MySQL workbench, ensure you can connect to your MySQL server. 

  1. Select Database > Connect to Database.
  2. Enter the IP address of the MySQL server, use temp userame.



Did you find this article helpful?

If so, consider buying me a coffee over at Buy Me A Coffee



Comments


Add a Comment


Please enter a5e3b7 in the box below so that we can be sure you are a human.