mySQL give permission to a computer IP address




To get a list of MySQL users:

mysql> select user,host from mysql.user;

Allow remote connections to your MySQL server

nano /etc/my.cnf

Now that the file is backed up let’s open this baby up for editing. When you have the file open you are going to want to look for this line:

bind-address =

What the above line does is limit connections to the localhost and only the localhost. You want to comment this line out by changing it to:

#bind-address =

Now save that file and restart MySQL with the command:

service mysqld restart

mysql -u root -p

Where root is the MySQL administrative user (most like it is root).

You will be prompted for the MySQL administrators password. After you have successfully authenticated you will have a new prompt that looks like:


You are now at the MySQL prompt. You only have one command to enter for this to work. You will want to enter this command carefully:

GRANT ALL PRIVILEGES ON *.* TO username@address IDENTIFIED BY “password”;

Where username is the username on the remote machine that will be connecting, address is the IP address of the remote machine, andpassword is the password that will be used by the remote user.

When that command is issued successfully you should see something like:

Query OK, 0 rows affected (0.00 sec)

As long as you get Query OK, you should be good to go.


Full Reff:

How to configure static IP address on CentOS 6.5 minimal

# vi /etc/sysconfig/network-scripts/ifcfg-eth0


Now, configure default getaway:

# vi /etc/sysconfig/network


Configure DNS Server

# vi /etc/resolv.conf

; generated by /sbin/dhclient-script



# /etc/init.d/network restart

Cent OS telnet: connect to address Connection refused

yum install xinetd
yum install telnet


1. vi /etc/xinetd.d/telnet

2. you will see file like that, you will see last line disable, replace disable = yes to disable = no and save file.

service telnet
flags = REUSE
socket_type = stream
wait = no
user = root
server = /usr/sbin/in.telnetd
log_on_failure += USERID
disable = yes (need to replace with no)

3. restart xinetd service

# /etc/init.d/xinetd restart

4. if it still not work, then iptables is blocking that, you need to flush iptables or turn off service like

# iptables -F
# iptables -X

# /etc/init.d/xinetd stop

By simplemsexchange Posted in Linux

Exit/save edit to sudoers file? Putty SSH

To make changes to sudo from putty/bash:

  • Type visudo and press enter.
  • Navigate to the place you wish to edit using the up and down arrow keys.
  • Press insert to go into editing mode.
  • Make your changes – for example: user ALL=(ALL) ALL.
  • Note – it matters whether you use tabs or spaces when making changes.
  • Once your changes are done press esc to exit editing mode.
  • Now type :wq to save and press enter.
  • You should now be back at bash.
  • Now you can press ctrl + D to exit the session if you wish.
By simplemsexchange Posted in Linux

How to Install DNS (BIND) on CentOS 6.2

Step 1. Installation of required packages.

We use yum to install BIND packages.

# yum -y install bind bind-libs bind-utils

Step 2.  Set BIND service start on system boot (Optional)

# chkconfig –-level 35 named on

Step 3. Start named service for generating some default configuration files.

# service named start

Step 4. Edit main configuration file and add zone entry of

# vi /etc/named.conf
Check allow query {any;}

add the following lines:

zone "." IN {
        type hint;
        file "";
zone "" {
        type master;
        file "";
zone "" {
        type master;
        file "";
include "/etc/named.rfc1912.zones";

Step 5. Create Zone files which we mentioned in named.conf file.

# cd /var/named
(If permission denied then type the following)
# chmod 775 /var/named/

 # vi $ORIGIN $TTL 3D @       SOA (12 4h 1h 1w 1h) @       IN      NS     IN      A www                                     IN      A # vi $ORIGIN $TTL 3D @       SOA (12 4h 1h 1w 1h) @       IN      NS 211     IN      PTR

Step 6.  Restart BIND Service

# service named restart

Step 7.  Test your DNS server

Note : Before testing , make sure your /etc/resolve.conf file contain DNS server ip that has been set up.

# cat /etc/resolve.conf


# nslookup




# nslookup


Address:      name =


By simplemsexchange Posted in Linux

CentOS: Enable CentOS GNOME Desktop

If you by default in text mode of Centos, you can change the graphical mode by typing: startx


Further details explanation from here are as follows:


Variable that I used as below:

OS: CentOS 6.2 64bit
Desktop environment: GNOME

1. Using yum, we will need to install X Windows System  as the based for GUI and rich input device capability:

$ yum groupinstall -y 'X Window System'

2. Only then we can install GNOME desktop environment on top of it:

$ yum groupinstall -y 'Desktop'

3. Since previously the server is running on CLI mode, we need to change some value to tell CentOS to boot up in the GUI mode. Open /etc/inittab via text editor and change following line:




4. Reboot:

$ init 6

Note: You can switch from GUI to CLI mode manually by using following method:

GUI to CLI: Ctrl + Alt + F6
CLI to GUI: Ctrl + Alt + F1

If you want to start the desktop from CLI console (not SSH session), use following command:

$ startx

In some cases, when you login into the system via GUI, you will see some kind of weird boxes replacing the fonts. You can overcome this problem by installing fonts group via yum:

$ yum groupinstall -y fonts

Done! We now have user-friendly interface like below:

By simplemsexchange Posted in Linux