MySQL Server Configuration [Step by step]

MySQL Server Configuration [Step by step]

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

Top 99 Linux operating systems according to Distrowatch [2016][Updated]
How to make folder without name & icon [2016]
[Most Wanted Trick] Disable/Block Photo Tagging on Facebook [Updated]

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

WORDPRESS: 0
DISQUS: 0
banner