I am in the process of trying to learn PHP & MySQL. So far I have figured out how to create a MySQL database using the excellent Total Hosting tutorials. However, I just can't get Dreamweaver to connect to the database and show the tables and I can't figure out why!
I have created a database called "user", which has been renamed "competi_user" as I created it through cpanel. I also created a user which is able to access the database called "competi" which was also renamed "competi_competi" as before. I then created a table called user and populated it with a couple of records.
I then went to Dreamweaver and setup a site with a testing server. I don't have PHP or MySQL locally so I decided to use the webserver as the testing server.
Server model: PHPMySQL
Access: FTP
FTP host: Mywebsite.com
Login: MyLogin
Password: MyPassword
Testing this showed that the ftp link works. So far, so good. (Also setup local and remote stuff too.)
I then go to the Application - Databases panel to try and create a connection from Dreamweaver to my testing server.
Connection: MySQL Connection
Connection name: dbUserConnection
My SQL Server: localhost
Username: competi_competi
Password: the password
Database: competi_user
When I click test I get "Unknown error". Very helpful. I have tried changing the SQL server name to the webserver name but this makes no difference.
Anyone have any ideas what I am doing wrong? I am going mad trying to work it!!! Any help, tips, prompts and hand holding would be appreciated!