MySQL Server Configuration [Step by step]

MySQL Server Configuration [Step by step]

MySQL Server Configuration Step By Step Guide with screenshot 100% working

7 Wireless Router Problems and How to Solve Them
Things To Do When You Have Forgotten Your Wireless Router Password
How to Reset or Change your Router’s Login Information

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

DISQUS: 0