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;
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;