473,388 Members | 1,426 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

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 6066
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ryan Schefke | last post by:
------=_NextPart_000_0077_01C34C8B.2B90C960 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit ..I just sent this out to the win32 distribution list but no one has...
0
by: craig | last post by:
RH 9. # ./bin/safe_mysqld & 15246 # Starting mysqld daemon with databases from /usr/local/mysql/data 030929 19:42:54 mysqld ended this is what I just installed # rpm -iv...
3
by: Kirk Soodhalter | last post by:
Hi, This started as a phpmyadmin problem, but has somehow morphed into a mysql problem. I don't know how to fix it. I am posting the conversation from a php newsgroup since it started there. ...
5
by: MLH | last post by:
I'm supposed to set a password for the MySQL root user. The output of mysql_install_db instructed me to run the following commands... /usr/bin/mysqladmin -u root -h appserver password mynwewpasswd...
4
by: Ian Davies | last post by:
Hello all The following code allows me to connect to a local MySQL database on my pc from a VB6 project. **************************************************************************** ** Dim...
2
by: zhengfish | last post by:
Hi,All, I try to install mysql-5.0.15 on RHEL3-U5. But It give me a error. MySQL-client-standard-5.0.15-0.rhel3.i386.rpm MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm...
5
by: news.telia.net | last post by:
Hi! I have a question. I have installed php and mysql on an apache-server on windows and I can't connect to the server. I tried to create a database (since I am trying to learn howto). My...
4
by: Richard | last post by:
Hi All, I've been trying to build a Ruby-on-Rails plus MySQL application. I'm running Ruby 1.8.2, Rails 1.1.4 and MySQL 5.0.15-nt over WinXP-Pro/SP2. I run under an Administrative account. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.