MySQL basic commands

On a windows server the MySQL executables folder by default will be installed in a folder like

C:\Program Files\MySQL\MySQL Server 5.1\bin

Executables in this folder will be

myisamchk.exe
myisamlog.exe
myisampack.exe
myisam_ftdump.exe
mysql.exe
mysqladmin.exe
mysqlbinlog.exe
mysqlcheck.exe
mysqld-debug.exe
mysqld.exe
mysqldump.exe
mysqlimport.exe
MySQLInstanceConfig.exe
mysqlmanager.exe
mysqlshow.exe
mysqltest.exe
mysql_client_test.exe
mysql_upgrade.exe
my_print_defaults.exe
perror.exe
replace.exe
resolveip.exe

Use this to create a database:

# mysqladmin create <db-name>

Assign privledges:

# mysql -u root -p

# mysql> use mysql;

# mysql> grant all privileges on <db-name>.* to <db-user>@webserver.com

-> identified by ‘<db-password>’;

mysql> flush privileges;

Test connection to the database:

# mysql -u <db-user> -h <db-server> -p <db-name>

Type quit; or exit; to leave the MySQL utility.

Other sites with mysql commands:

For Joomla setup – http://www.joomlawebserver.com/joomla/joomla-1.5-installation/01.-basic-joomla-1.5-installation.html

http://inpics.net/mysqlbasics.html

http://www.analysisandsolutions.com/code/mysql-tutorial.htm