D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Default mysql user name and password

 

Thomas Arrow wrote:
Hi,
Im trying to install mambo on my FC3 server. When I set it up i dont remember setting a mysql user or password. Does anyone know the defaults so I can use sqladministaration. I looked in the shadow file and found a user called mysql but I don't know if that is the user I need to create a new data base.
Any help much apperciated.
Thanks
--
Tom (the younger)

--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe. FAQ: www.dcglug.org.uk/linux_adm/list-faq.html



If I understand you the mysql user that you have found is the system user that mysqld runs as, not a mysql db user. If you see what I mean.

If you haven't set any password / user when you installed mysql, then the default user is "root". I don't think that there is set a default password for this user, in otherwords it is blank.

Try "mysql -uroot -p" and enter a blank password when prompted.

Whatever it is you can / should set the root password to something else and "flush privileges" afterwards.

I like to create a new mysql user, with minimal rights, for each program or site that uses mysql. But I imagine that everybody has their own ideas.

I hope this helps

Wills

--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe. FAQ: www.dcglug.org.uk/linux_adm/list-faq.html