MySQL Forums
Forum List  »  Newbie

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--

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.