Articles

 [SQL2.01] How do I connect to my MySQL database from a Perl CGI script?

Perl's DBI module provides an interface to MySQL databases for CGI scripts. A commented example...

 [SQL2.02] How do I query a MySQL database from a PHP script?

Use the following outline to connect and begin querying the MySQL server from within your PHP...

 [SQL2.03] How do I connect to MySQL with ASP?

This applies to Windows Hosting accounts only.You will need to use a DSNless connection which can...

 [SQL2.04] How do I set up the MySQL connection using Dreamweaver?

1. Open Dreamweaver2. Click File>New3. Choose “Dynamic Page” in left frame and then “PHP” (or...

 [SQL2.05] Can I rename my database getting rid of the 'web-' part of the name?

Unfortunately this isn't possible as the convention is required for backing up the data on the...

 [SQL2.06] What are the default / allowed privileges for MySQL databases?

By default on all MySQL databases the current privileges are given -SELECT, INSERT, UPDATE,...

 [SQL2.07] Can I use CocoaMySQL?

Yes you can.Please ensure you are using CocoaMySQL 0.7b5 or later. Please note that CocoaMySQL...

 [SQL2.08] How do I grant permissions to a MySQL standalone user?

MySQL standalone users provide additional security in certain advanced applications of database...