MySQL Sharing on Local Network

MySQL Sharing on Local Network

First, let's go to our MySQL directory. The directories with Wamp installed are usually as follows.

C:\wamp64\bin\mysql\mysql5.7.36\bin

After specifying our directory, let's follow the steps below;

  • Let's log into the Firewall.
    mysql_paylasimi_1


  • Select Allow an app or feature to bypass Windows Defender Firewall.
    mysql_paylasimi_2

  • Select Change settings and then Allow another app.

    mysql_paylasimi_3

  • Let's choose the directory where mysqld.exe is located at the beginning of the article and add mysqld.exe.

    mysql_paylasimi_4

After allowing our mysqld.exe

Login to our MySQL Console

Mysql –u root –p

after typing the line

Enter Password: (We enter our password.)

With the codes below, we create a new user on the root2 island and give access from all ip addresses.

If QUERY OK does not appear after each line of code we add, be careful not to write the codes incorrectly. If you do your operations correctly, you will see the QUERY OK statement on the console after the codes.

CREATE USER 'root2'@'localhost' IDENTIFIED BY 'your password';

GRANT ALL PRIVILEGES ON *.* TO 'root2'@'localhost' WITH GRANT OPTION;

CREATE USER 'root2'@'%' IDENTIFIED BY 'your password';

GRANT ALL PRIVILEGES ON *.* TO 'root2'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Son yazılar

Kategoriler

Türkçe English Deutsch Dansk Español Română