MySQL install password?
steve
sfreilly at roadrunner.com
Sat Jan 10 17:21:47 UTC 2009
stan wrote:
> On Sat, Jan 10, 2009 at 11:37:15AM -0500, steve wrote:
>> stan wrote:
>>> I am trying to get ampache running on my Ubuntu machine. This package uses
>>> MySQL. I looked at the MySQL 5.0 docs in /usr/share/docs, and it syas there
>>> that I should be able to set the MySQL root user password with:
>>>
>>> /usr/bin/mysql -u root -D mysql -e "update user set
>>> password=password('new-password') where user='root'"
>>>
>>> But when I try that, it fails, saying I need a passwrd. How can I find out
>>> what password got set by the installer?
>>>
>> try this:
>>
>> http://www.ubuntugeek.com/reset-the-root-password-on-mysql.html
>
> Looks handy, but it does not seem to work in Intrepid
>
> root at boo-boo:/etc/init.d# /etc/init.d/mysql reset-password
> Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status
>
duh, sorry, wrong one, this will work
sudo dpkg-reconfigure mysql-server-5.0
--
Steve Reilly
http://reillyblog.com
More information about the ubuntu-users
mailing list