Can't connect to MySQL Server on "mydomain.tld" (10060)
I cannot seem to establish a MySQL Workbench connection to my Raspberry Pi 3 on a Raspbian based OS. I have a dynamic IP-Adress, that is why I am using a dynamic dns service by no-ip.com. My webserver and FTP server are working perfectly. The web server even successfully tried to reach out to the mysql server to find a user when using the login system. The only problem I have is that I cannot connect to the database using MySQL Workbench on any user. Root and the newly created user cannot connect to it.
I tried editing the my.cnf file in /etc/mysql/ uncommenting the bind-address or even setting it to 0.0.0.0 and then reloading and restarting the MySQL service. But it does not seem to work.
The error message is Cannot connect to 127.0.0.1:3306
Edit: The Raspberry Pi 3 and I are both on the same network.
Edit 2: So I have installed PhpMyAdmin after 1 hour since I asked my question, and PhpMyAdmin is working perfectly. I don't know if this is MySQL Workbench fault or not, but I will leave the question open. I guess I will be using PhpMyAdmin instead..
The problem ultimately ended up being that MySQL was not seeing the hostname properly and was rejecting connections based on this. It was verified to work by allowing connections from any host. Advised to lock it back down to the connecting host.
- Combine rows if the dates exist in another row
- Distinguish between two maximum values in a column with Power Query
- Power Query Conditional JOIN - JOIN with WHERE clause
- Calculate combinations for a range of text values in excel
- How to update a column's values in Power BI M Language
- What's the difference between DAX and Power Query (or M)?
- Sorting issue when consolidating monthly data into a year to date file. Using query, sorting by day, time, and letter
- Power Query `List.Generate` runs too slow
- Custom Colum based on specific dates in powerquery
- How do I properly use table.group in a PowerQuery query to dynamically summarize different rows and columns?
- Excel Power Query syntax issue transform multiple columns of records
- How to capitalize only first letter of a sentence
- Power Query Import For Power BI with group by on SelectRows
- Get data from config table cell when loading data source with power query
- Translate Excel Formula into Power Query
- Counting matching pairs of letters in lists of bigrams in Power Query M
- Bigrams of a string in Power Query M
- Power Query code to refer to another query (and how buffering works)
- M code for the equivalent of of Left (string, len(string)-11)
- How to add a missing column to the Transform Sample File
- How to add or insert ' (single quotes) for every string in a list in which strings are separated by commas in Power Query
- Power BI M code Split column from Lowercase to Uppercase won't include diacritics (accents)
- M Code(Power Query) to Remove Empty columns that runs fast
- How to find the value with date closest to another date
- Error when build AOSP 14 - internal error: undefined variable CTS_TEST_SUITES_DEFAULT
- Call a table using a dynamic identifier
- Problem getting the value from a cell using M in excel
- How to rename columns based on the data within them in Power Query M?
- Power Query return a field name based on parameter
- Power Query: after combining 2 tables got something strange