MySQL Server Configuration [Step by step]

MySQL Server Configuration [Step by step]

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

How To Assign Keyboard Shortcuts for Programs ?
How To Recover Ubuntu Linux Distribution ? [Updated]
Installing Oracle JAVA JDK 8 on Ubuntu [Offline] [ 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

DISQUS: 0