Re: How to handle multiple MySQL installations for database design, and web development
Posted by:
Trevor Pan
Date: August 30, 2018 07:27PM
Peter Brawley Wrote:
-------------------------------------------------------
> The simple bit is that your "access denied"
> message indicates the password offered doesn't
> match what's been set up for that user.
--
> yes.
> --
> 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?
--
I could not log in. So I found a post and changed the password and then forgot it after a few days. So, the posts I've referenced were used to clear the old password to start afresh. The databases are still there.
However, I retried that last night and could log in fine. After restarting the machine today, I find that it does not remember the '' password.
> With regards to the password, this is per the laravel valet settings. On a local web development machine there is no need for a password. It is standard to not have a password. One is added to the environment variable on a live server when the site is published.
>--
> 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.
--
This is where I'm a bit confused. I've installed an installation originally for the MySQL Workbench. This has worked in the past. It was a basic install on a home environment so 'root'@'localhost' had 'root' as password.
The laravel valet recommends installing MySQL 5.7 via composer. I did that.
There was an earlier time when I was interested in using MAMP for a local web development. It has an MySQL install, too on this machine.
I think there are at least (3) installs, but perhaps more.
I've since settled on using laravel as a php framework and trying out valet as the local development environment.
--
>
> 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?
--
There are several installs of MySQL on the machine. As of now I'm using port 3306.
--
>
> 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.
-- hard to say.
Knowing what I've stated do you have a recommendation? Should I back up databases and reinstall just one MySQL?
I'm at a loss--