...

View Full Version : MySQL password - uploading to live site



aaronoafc
04-02-2013, 10:57 PM
Hi, Just wondering how this would work.

So when you install MAMP..you are given a root username and password (of root/root) right?

So say you create a site locally using this, then you want to upload it to a web hosting site so it can go live on the web, you wouldn't want to be using the default root username and password for your local MySQL server would you? Or does it not matter?

Do people tend to install MAMP and change this immediately so its done for future? if so, how do you change? I'm going to re-install MAMP and do this if this is the case.

Thanks in advance

Old Pedant
04-03-2013, 12:14 AM
Well, I certainly wouldn't leave it as root/root even on my local server.

In any case, if you are uploading the database to some web host, more than likely they will assign both the user name and password to you. It's extremely unlikely that they will give you root access. (I know, for example, that GoDaddy doesn't allow this when you ask them to set up a MySQL DB for you.)

aaronoafc
04-03-2013, 08:41 AM
Well, I certainly wouldn't leave it as root/root even on my local server.

In any case, if you are uploading the database to some web host, more than likely they will assign both the user name and password to you. It's extremely unlikely that they will give you root access. (I know, for example, that GoDaddy doesn't allow this when you ask them to set up a MySQL DB for you.)

Do you know how to change it mate for local use? Ive troed a couple of things from google and neither have worked

aaronoafc
04-03-2013, 08:01 PM
This is driving me mad now! Managed to change the password, however when I stop and start the MAMP servers I get this error shown in the screenshot? There must be some file somewhere that still thinks I am using the old password!?!?!

Any ideas guys?

Old Pedant
04-03-2013, 11:40 PM
Never used MAMP. Just installed MySQL by itself. Never seen that type of screen.

sunfighter
04-05-2013, 01:14 AM
See if this vid helps: http://www.youtube.com/watch?v=X4FvTPkRUoI



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum