Tag Archives: Remote Access

MySQL Tip of the day (GUI Tools, Remote access, Complex Passwords)

MySQL TIP OF THE DAY #1:

If you can’t remotely connect to your MySQL server using Query Analyser / Administrator GUI Tools, try replacing your password with a simpler one, as the GUI Tools just ain’t that clever.

details:
It’s taken me around 20 minutes to realise that MySQL GUI Tools running Mac OS X do not appear to like complex passwords, such as this one

932_h5@@d-p23iuf

I honestly thought I was being more security aware by using this rather than my usual fairly memorable passwords but it appears that the GUI tools trip up over some of the characters (probably the ‘@’ signs), so that even though I can access the server using these credentials in an SSH session, the same login information will generate the ubiquitous MySQL “can’t connect” error.

Cannot connect to MySQL instance

Cannot connect to MySQL instance

икони