It implements the relational model and uses Structured Query Language (better known as SQL) to manage its data. I hope this will helps you to host your application and database on their own machines.MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. ConclusionĬongratulations! you have successfully configured MySQL server for remote access. +-+ | Database | +-+ | information_schema | | mydb | | mysql | | performance_schema | | sys | +-+ 5 rows in set (0.00 sec)ġ92.168.0.100 : IP addres of your MYSQL server. You can now list the databases with the following command: Type '\c' to clear the current input statement. Other names may be trademarks of their respective owners. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Your MySQL connection id is 1682 Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu) Copyright (c) 2000, 2020, Oracle and/or its affiliates. Welcome to the MySQL monitor. Commands end with or \g. Once the connection has been made, you should see the following output: You will need to provide the password of the myuser as shown below: Here, we will grant access to the remote system with an IP address 192.168.0.101 to connect to all MySQL databases. Mysql> FLUSH PRIVILEGES mysql> EXIT Grant Access to Specific IP and All Databases Mysql> GRANT ALL PRIVILEGES ON mydb.* TO Query OK, 0 rows affected (0.02 sec) Mysql> CREATE DATABASE mydb mysql> CREATE USER IDENTIFIED BY 'password' Password : Password of the MySQL database user.įirst, log in to MySQL server with the following command: Myuser : Name of the MySQL database user.ġ92.168.0.101 : IP address of the remote system. Next, flush the privileges and exit from the MariaDB shell with the following command: Mysql> GRANT ALL ON mydb.* to IDENTIFIED BY 'password' WITH GRANT OPTION Next, grant permissions to the remote system with IP address 192.168.0.101 to connect to a database mydb with the following command: Mysql> CREATE DATABASE mydb mysql> CREATE IDENTIFIED BY 'password' Provide your root password when prompt then create a database named mydb and a user with the following command:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |