Question
Quick Help Needed - Connecting to MySQL DB
(I'm new to MySQL) - I'm trying to connect to a MySQL DB
(below) - in cf admin I tried:
Database = TEST1
server = localhost
port = 8888
user = root
pass = root
error = Connection verification failed for data source: house1
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection
* I'll bet I need to create a 'normal' user tied to this DB - but I Don't know how...?
---
* GEAR: CF8 mac 10.4.10 tiger w MAMP install of php -phpMyAdmin - mysql and apache - working
I went to:
http://localhost:8888/MAMP phpMyAdmin
- and created new empty database called TEST1
- now I need to create a user - how do I do that?
- I tried to log in using using MySQL administrator APP using :
The MySQL Database can be administrated with phpMyAdmin.
To connect to the MySQL Server from your own scripts use the following connection parameters:
Host: localhost
[Port: 8889]
User: root
Password: root
but the app errored: access denied for root@localhost using password "yes" code 1045
Q: How do I create a user for this database TEST1?
Q: How do I restore in this database TEST1 from another backup (which I have)?
Database = TEST1
server = localhost
port = 8888
user = root
pass = root
error = Connection verification failed for data source: house1
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection
* I'll bet I need to create a 'normal' user tied to this DB - but I Don't know how...?
---
* GEAR: CF8 mac 10.4.10 tiger w MAMP install of php -phpMyAdmin - mysql and apache - working
I went to:
http://localhost:8888/MAMP phpMyAdmin
- and created new empty database called TEST1
- now I need to create a user - how do I do that?
- I tried to log in using using MySQL administrator APP using :
The MySQL Database can be administrated with phpMyAdmin.
To connect to the MySQL Server from your own scripts use the following connection parameters:
Host: localhost
[Port: 8889]
User: root
Password: root
but the app errored: access denied for root@localhost using password "yes" code 1045
Q: How do I create a user for this database TEST1?
Q: How do I restore in this database TEST1 from another backup (which I have)?
