Logging into existing MySQL server on Ubuntu AMI (public AMI: ami-fb00ca92)

[JohnB]

Hi,

I'm just getting started with deployment of an app to EC2.  I'm using a public cloudbiolinux AMI ami-fb00ca92 (Ubuntu 11.10, kernel:3.0.0.-12-virtual)
By default there is an existing mysqld process running by user 'mysql'.

Typical root access with null password isn't working.

ubuntu@[my_ip]:~$:mysql -h localhost  -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

My application needs to set up a database and I wanted to explore using this existing server. We don't have a budget or the need for RDS at this point of development.
That's why I'm exploring the existing mysql server.

Question: Are there default (existing) credentials to log in to the running instance of mysql on this particular AMI.

Thanks,

John

[Tim Booth]

Hi John,

I can't answer your question directly regarding how this was configured,
but the normal way to (re)set the root password for the MySQL server is:

sudo dpkg-reconfigure --priority=low mysql-server-5.1

Probably the server version on the latest AMI is higher than 5.1 - I'm
on a Lucid box just so I can't check. You can find out easily:

dpkg -s mysql-server | grep ^Depends

Does that fix it?

Cheers,

TIM

> --
> You received this message because you are subscribed to the Google
> Groups "cloudbiolinux" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/cloudbiolinux/-/dZdlyLwAuRsJ.
> To post to this group, send email to cloudb...@googlegroups.com.
> To unsubscribe from this group, send email to cloudbiolinux
> +unsub...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/cloudbiolinux?hl=en.

--
Tim Booth <tbo...@ceh.ac.uk>
NERC Environmental Bioinformatics Centre

Centre for Ecology and Hydrology
Maclean Bldg, Benson Lane
Crowmarsh Gifford
Wallingford, England
OX10 8BB

http://nebc.nerc.ac.uk
+44 1491 69 2705

--
This message (and any attachments) is for the recipient only. NERC
is subject to the Freedom of Information Act 2000 and the contents
of this email and any reply you make may be disclosed by NERC unless
it is exempt from release under the Act. Any material supplied to
NERC may be stored in an electronic records management system.

[JohnB]

Hi Tim,

It worked perfectly. Thank you for the quick post and complete answer.

Cheers,

John

--
Tim Booth
NERC Environmental Bioinformatics Centre