Edit file:

/etc/my.cnf

Comment out line:

skip-networking

So should look like this:

#skip-networking

Restart MySQL

/etc/init.d/mysqld restart

To find a string in a certain field and replace it with another string:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html

To start mysql server:

/etc/init.d/mysqld start

To stop mysql server:

/etc/init.d/mysqld stop

To restart mysql server

 /etc/init.d/mysqld restart

Source: http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/

Comment out “skip-networking parameter” in /etc/my.cnf

Run this command on the command line to load a mysql database dump file

mysql -u yourusername -p -h localhost databasename < data.sql

Run this command to dump a database via command line

mysqldump –u yourusername –p yourdatabasename > yourdumpfile.sql