MySQL Server Configuration Step By Step Guide with screenshot 100% working
Hey Guys Today I’m posting a blog for the student who wish to install MySQL server and want to configure it. So follow the given steps.
MySQL Server Configuration Steps:
Step 1 : Type The command …
sudo nano /etc/mysql/my.cnf
Step 2 : Enter the password.
Step 3 : Now You will see the my.cnf file.
Step 4 : Find the following code in my.cnf File
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#]
Step 5 : Now add # before the skip-external-locking
#
And bind-address 127.0.0.1 change to Your IpV4 address [internal ip address] How To Find IP ?
127.0.0.1
#skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 192.168.0.102
#
Step 6 : After editing press Ctrl+X and press Y to save modification.
Step 7 : Now enter the following command.
sudo service mysql restart
Step 8 : Now your MySQL server is ready to use.
Thanks guys, Enjoy learning and please do comment and share the post.
COMMENTS