First, let's go to our MySQL directory. The directories with Wamp installed are usually as follows.
After specifying our directory, let's follow the steps below;
Let's log into the Firewall.
Select Allow an app or feature to bypass Windows Defender Firewall.
Select Change settings and then Allow another app.
Let's choose the directory where mysqld.exe is located at the beginning of the article and add mysqld.exe.
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;