Hi ruud,
Have you tried running 'mysql' in a terminal? One thing that aggrevates me
about SuSe (or YaST more precisely) is that it adds an extra layer of
abstraction between the user and the software. If you're intending to use
MySQL for anything important I would recommend installing it from source.
But I digress... Open a terminal and try this:
mysql -u root
If this brings you to the 'mysql>' prompt then you can set the password to
anything you like with a couple simple statements:
mysql> use mysql;
mysql> UPDATE user SET Password=Password('my_pw') WHERE User='root';
The above statement would set your password to "my_pw". Note that strings
should be single quoted. Of course if you don't get the 'mysql>' prompt
you may have to consult the documentation or find a SuSe expert!
HTH,
Bill
On Thu, 04 Mar 2004 19:44:13 +0100, ruud wrote:
I installed it on Suse professional 8.1. When you startup there is a login
screen with "MySQL server". When I left password and/or both open, it
won't startup end give the sign login fails
"Aggro" <sp**********@yahoo.com> schreef in bericht
news:1A*************@read3.inet.fi... ruud wrote:
> I just installed MySQL server 3.23.58-1. Now I can't find the password en > can's change the settings. Who knows this password?
Default password is that there is no password. You can log in to mysql
for example with this command:
mysql -u root
There are also ways to change the password and you will find those
methods from the MySQL manual.
http://www.mysql.com/doc/en/index.html
Which you _will_ bookmark right away, because you will need it later.