469,112 Members | 2,016 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,112 developers. It's quick & easy.

default MYSQL server password

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?
Jul 19 '05 #1
9 5888
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.
Jul 19 '05 #2
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.
Jul 19 '05 #3
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.
Jul 19 '05 #4
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.

Jul 19 '05 #5
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.

Jul 19 '05 #6
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.

Jul 19 '05 #7
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.


Jul 19 '05 #8
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.


Jul 19 '05 #9
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.


Jul 19 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ryan Schefke | last post: by
reply views Thread by craig | last post: by
3 posts views Thread by Kirk Soodhalter | last post: by
5 posts views Thread by news.telia.net | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.