Mysql – Using XAMPP and Mysql Workbench together

MySQLmysql-workbenchxampp

There are some related posts to this but I still can't figure this out. I have a working install of XAMPP(latest version) and MySQL Workbench 8.0.17 installed. I just want to be able to use Workbench with the MySQL that ships with the XAMPP install.

In the latest version of XAMPP, it first sets an IP address before I can start apache and mysql. MySQL seems to be running on port 3307.

Here is the Workbench screen to make a new connection. XAMPP is running on localhost – should that be my hostname?

If I try a localhost or 127.0.0.1 hostname with port 3307 (where I think XAMPP's MySQL is) I get this popup alert. If I continue, I still don't see any of my databases listed on the main screen.

Best Answer

This is the way I have used to connecting MySQL workbench to Xampp MySQL.

01) Click on the Plus icon.

02) Check the Xampp MySQL port number.

03)Type the connection name and check the port number with your Xampp MySql port number.

04) Click on the "Continue Anyway" button.

05) Then click on the "OK" button to save the connection.

06) Now you can see the connection you just created and click on it to connect to the MySQL database.

07) Just try to run some SQL code to if properly connected to Xampp Mysql.

Related Solutions

Mysql – Should I use the datetime or timestamp data type in MySQL

Timestamps in MySQL are generally used to track changes to records, and are often updated every time the record is changed. If you want to store a specific value you should use a datetime field.

If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go with the native format. You can do calculations within MySQL that way ("SELECT DATE_ADD(my_datetime, INTERVAL 1 DAY)") and it is simple to change the format of the value to a UNIX timestamp ("SELECT UNIX_TIMESTAMP(my_datetime)") when you query the record if you want to operate on it with PHP.

Mysql – How to get a list of user accounts using the command line in MySQL

Use this query:

SELECT User FROM mysql.user;

Which will output a table like this:

+-------+
| User  |
+-------+
| root  |
+-------+
| user2 |
+-------+

As Matthew Scharley points out in the comments on this answer, you can group by the User column if you'd only like to see unique usernames.

Best Answer

Related Solutions

Mysql – Should I use the datetime or timestamp data type in MySQL

Mysql – How to get a list of user accounts using the command line in MySQL

Related Topic