Re: How to handle multiple MySQL installations for database design, and web development

[Peter Brawley]

The simple bit is that your "access denied" message indicates the password offered doesn't match what's been set up for that user.

But much else in what you post is puzzling, eg why in the world did you try to reset the root password to 'nothing', and how did you try to do that?

Nor do I understand "How do you handle having a MySQL install for Workbench and an install for another program?" Do you mean you installed MySQL twice, once for Workbench and once for Sequel Pro? Having two db manager apps like WB and Sql Pro doesn't require having two installations of the server.

Also please explain "the server of one install prevents access to the other". Are there multiple mysql installations on this machine? What versions? What ports are they configured to use? How do you try to log in to each, and how do you know that being logged into one prevents being logged in to the other?

Also please explain "mysql -S ...". Is that a call to try to start the mysql server, or a call to invoke the mysql client program? And I don't recognise "-S" as an option for either the mysaql server or client.