How do I create a MySQL database?
If your account type includes MySQL databases, then log in to your Web Services Group Control Panel and select “MySQL Databases”, in the “Web Tools” section.
How do I connect to my MySQL database using CGI?
You can also choose to use Perl and the DBI Perl Module to access your database. A commented example: #!/usr/bin/perl use DBI; # Connect To Database # * The DBI interface to MySQL uses the method “connect” to make a # * connection to the database. It takes as it’s first argument # * the [...]
Can I use CocoaMySQL?
Yes you can. Please ensure you are using CocoaMySQL 0.7b5 or later. Please note that CocoaMySQL has now been abandoned and replaced by Sequel Pro:- http://code.google.com/p/sequel-pro/
How do I grant permissions to a MySQL standalone user?
MySQL standalone users provide additional security in certain advanced applications of database use by restricting the permissions of a certain user to operate on the database. By default a standalone user has no permissions – they must all be granted specifically. Do note that standalone users are not required for normal use – when MySQL [...]
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 scripts. You should connect to localhost for database connections, not the external IP or hostname of the server.. 1. Connect to the MySQL Server Use the following statement to connect to the database server. Substitute the username and password [...]
How do I set up the MySQL connection using Dreamweaver?
1. Open Dreamweaver 2. Click File>New 3. Choose �Dynamic Page� in left frame and then �PHP� (or any other type of dynamic page) in right frame. 4. Click Create (a new blank page will appear). 5. On the Tools window drop down the �Application� window and choose the �Database� tab. 6. Assuming a site has [...]
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 web servers.
What are the default / allowed privileges for MySQL databases?
By default on all MySQL databases the current privileges are given – SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES CREATE TEMPORARY TABLES, CREATE VIEW, and CREATE ROUTINE privileges can be granted on request to Support.
Database connections from ASP fail with ‘Client does not support authentication protocol requested by server’.
This applies to Linux hosting accounts only. Sun ONE ASP does not support the default authentication method used by MySQL 5. Instead it is necessary to make MySQL use the ‘old-style’ authentication. To do that, first log in to MySQL via phpMyAdmin or another MySQL administration program and then use the ‘old_password’ function to change [...]
I’m getting SQL errors on MySQL 5.0 saying it can’t find a column – but it’s there!
1054 – Unknown column ‘a.c’ in ‘on clause’ This can happen if you’re doing something like: SELECT * FROM a, b LEFT JOIN c ON a.d = c.e; …which looks, on the surface of it, fine. But it’s invalid SQL; bugs in earlier versions of MySQL (4.x) caused it to be parsed as above and [...]