SQL Error: Can't connect to MySQL server on 'localhost'...

[jPaul]

Hi Everybody,

I'm using Rapid PHP 2022 (17.7.0.248) and juss beginning to experiment with an MySQL database.
I created a database with WAMP PHPMyAdmin

I used View > SQL Explorer and created a new connection

Label: GuestList
Type: MySQL
Port: 3306
username: root
Password: null
Database: users

However, when I double-click the GuestList icon in the SQL Explorer I receive an error:

SQL Error: Can't connect to MySQL server on 'localhost' (10061)

Can someone direct me to documentation to resolve this, or even suggest a solution?

[Davidmenk3]

Hi Everybody,

I'm using Rapid PHP 2022 (17.7.0.248) and juss beginning to experiment with an MySQL database.
I created a database with WAMP PHPMyAdmin

I used View > SQL Explorer and created a new connection

Label: GuestList
Type: MySQL
Port: 3306
username: root
Password: null
Database: users

However, when I double-click the GuestList icon in the SQL Explorer I receive an error:

SQL Error: Can't connect to MySQL server on 'localhost' (10061)

Can someone direct me to documentation to resolve this, or even suggest a solution?

Hi,

It sounds like your MySQL server might not be running. Here are a few steps to help you resolve this:

Check if MySQL is running: Open WAMP and ensure the MySQL service is started. The WAMP icon should be green.
Verify port and firewall: Make sure port 3306 is open and not blocked by your firewall.
Correct connection settings: Double-check your connection settings in Rapid PHP. Ensure 'localhost' and port 3306 are correct.
For documentation, you can look at MySQL Connection Documentation.

If you continue to face issues, you might want to consider comparing MySQL vs Maria DB, as some users find MariaDB to be more user-friendly and compatible with their setups.

Hope this helps!