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 [...]
Can I use Access Databases on my package with Web Services Group?
We only offer MySQL databases on our packages. Microsoft Access Databases are not fully ODBC compliant as standard and as such can not be used in their native form on the packages we offer. However it is possible to convert Access Databases into a MySQL format and then use converted databases on our packages. There [...]
How do I connect to my MySQL database?
A simple php script to open a connection to a database Save this as .php and then whenever you want to access the database, just add include ‘.php’ to the top of a php script and the database can be queried using standard sql commands.
How can I upload my MySQL database?
There are numerous ways to upload a MySQL database, we would strongly recommend trying methods 2 and 3 Method 1 – phpMyAdmin You may use phpMyAdmin to load your database by using the Import link to upload a .sql file or by pasting the SQL script into a query window and executing it. For the [...]
How do I backup my MySQL database?
Backing up your MySQL database can be done in several ways: 1. Using the backup tool from the Web Tools section. 2. Using phpMyAdmin web interface 3. Using command line through shell access 4. Using MySQL Workbench (1) Using our backup tool Log into your Web Services Group Control Panel and click on Web Tools. [...]
How can I manage my MySQL database?
Once you have created a database using your Web Services Group Control Panel you will be able to manage it using phpMyAdmin. Once the database is created you’ll see a new option in the MySQL section of your Web Services Group Control Panel. You’ll now be able to Edit/Manage/Delete your databases. To manage your database [...]
Is there a graphical interface available for MySQL?
MySQL Workbench is a GUI for MySQL – it can be downloaded from http://wb.mysql.com/ . It provides a complete set of drag-and-drop tools to visually build, analyze and manage queries. Plus, the integrated environment provides: Query Toolbar to easily create and execute queries and navigate query history Script Editor giving you control to manually create [...]
How do I connect to another database on another server from my PHP script?
A connection is made to a database with the usual statement: mysql_connect(‘localhost’,’USERNAME’,’PASSWORD’); Where ‘localhost’ is the database on the same web server as the PHP script. If you want to connect to a database to another web server you would replace localhost’ to that of the IP address of the web server. The web server [...]
How do I connect to MySQL via SSH (telnet)?
You can connect to the server using SSH Telnet, once logged into the system you can access MySQL directly using the following command:- mysql -u username -p databasename You will then be prompted for the password for the database. This will then place you at the MySQL prompt, for information on the commands that you [...]
What is MySQL?
MySQL is a Relational Database Management System. A relational database adds speed and flexibility, by storing data in separate tables rather than putting all the data in one area. These tables are linked by defined relations making it possible to combine data from several tables upon request. Using a RDMS means it is possible to [...]