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 [...]
