Category Archives: Mysql

Using the Mysql monitor

start the server,then$mysql –user=****(your root account)or $mysql –user=**** –password=**** interactive mode:mysql>help or mysql>help contents or mysql>help data manipulation or mysql>help show databases if you used a nonstandard socket file when starting your server,you will need to provide the details to … Continue reading

Posted in Mysql | Leave a comment

Configuring a server

mysql program files : /usr/bindatafiles: /var/lib/mysqlserver log files: /var/log/mysql or /var/log/mysql.log /etc/init.d/mysql startup script sudo /etc/init.d/mysql start sudo /etc/init.d/mysql stop

Posted in Mysql | Leave a comment