Nov 8, 2009
Pages: 1, 2

What Is Mysql's Default Root Password? - Just installed in on my Linux box

free web hosting
Open Discussion > MODERATED AREA > Computers > Software

What Is Mysql's Default Root Password? - Just installed in on my Linux box

michaelper22
I installed SuSE Linux 9.1 Professional on an old computer recently. I installed MySQL server (version 4.0.18), Webmin (version 1.250) and Usermin (version 1.180). If I try to connect to the MySQL server with the username root and no password, I get an invalid login error from Webmin, Usermin and mysql-cc. What is the default password, and how can I change it? I am very excited to be learning Linux (after a long journey through Windows-land), but get frustrated on loopholes like these.
Also, an a different note, why would the system stop loading after a certain point (towards the end, don't remeber where) if I have my USB drive plugged in before booting?

Comment/Reply (w/o sign-up)

jlhaslip
The initial Mysql password is blank according to this info for mysql ver 5.0. YOU WILL HAVE TO READ THE MANUAL FOR YOUR SPECIFIC VERSION. One of the first things they reccomend is to set a new root password and run the Grant table which controls access to the Database.

QUOTE
After a fresh installation, you should connect to the server and set up your users and their access permissions:

shell> mysql -u root mysql
The server should let you connect because the MySQL root user has no password initially. That is also a security risk, so setting the password for the root accounts is something you should do while you're setting up your other MySQL users. For instructions on setting the initial passwords, see Section 2.9.3, “Securing the Initial MySQL Accounts”.


The manuals are available at mysql.com either for online reading or by downloading. If you have installed it locally, probably best to download it.

Hope this helps.

 

 

 


Comment/Reply (w/o sign-up)

OpaQue
Try "su" as username and password is "" (blank).

Comment/Reply (w/o sign-up)

Inspiron
I'm not sure about MySQL but I guess you can get some references here..
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
http://www.experts-exchange.com/Databases/...Q_20678779.html

Comment/Reply (w/o sign-up)

leiaah
The default user is root and the password is, as they say blank for default.

You can set the root password by typing this:
CODE
# mysqladmin -u root password 'new-password'


You can then login by typing this:
CODE
# mysql -u root –p

Then you'll be prompted to provide the password you specified earlier.

You also might want to delete the anonymous user in the User's table. The default configuration of MySQL allows any user access to the system without
providing a username or password.

Delete the user by typing this:
CODE
# mysql -u root –p
mysql> use mysql
mysql> delete from user where User='';
mysql> quit

Comment/Reply (w/o sign-up)

Trap FeedBacker
I've changed the password with:

mysqladmin -you root password foo

When I run:

mysql -you root �p and enter foo when prompted, I get:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Ideas?

Comment/Reply (w/o sign-up)

FeedBacker
how to establish mysql database connection with php code
What Is Mysql\'s Default Root Password?

Hi,I have installed easy php1.8 on to my system and I created a database and tables in it.I'm trying to send the form data written in html to my database using php code.I'm getting errors like

Access denied for user@localhost using password (yes)

Here I didnt used any username or password or it was not asked during installation.So,because of the above error I'm unable to connect to the database.Hence I'm unable to send the form data tomy database table.I dontknow whether there may be any default passwords or not.

Please help me out

Comment/Reply (w/o sign-up)

FeedBacker
Same problem with my mysql installation
What Is Mysql\'s Default Root Password?

Replying to Trap FeedBacker

Even I just installed my mysql. It dint prompt for any password when it was installed nor did the blank password work. It returs with the same error when I try to open sql or try to change the password... Any help?

-reply by Rajaram

Comment/Reply (w/o sign-up)

Framp
Try stopping the mysql daemon
CODE
/etc/init.d/mysql stop

Run
CODE
mysqld_safe --skip-grant-tables &

Enter as root
CODE
mysql -u root -p


To change root password
CODE
mysql client - mysql -u root

and write
CODE
use mysql
update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;

Comment/Reply (w/o sign-up)

iGuest-Drew
Yes!!!
What Is Mysql\'s Default Root Password?

Replying to Framp
Dude I've been searching for an answer ALL DAY LONG! Thank you so much this helped tons!

-reply by Drew

Comment/Reply (w/o sign-up)



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Pages: 1, 2
Similar Topics

Keywords : mysqls, default, root, password, installed, linux, box

  1. File Manager In Puppy Linux
    (5)
  2. Media Player Linux
    (3)
    Hi all I'm thinking of installing linux studio, just to give it a go. it looks pretty good from
    what I'm looking at. I was wonderring what's a good media player for linux? Something
    simmilar to winamp, WMP, iTunes, QCD/QMP. Something with a library that can handle 20 or so gig of
    music, something really stable. nothing too fancy, As far as advanced features go an EQ and being
    able to chance settings with the playback engine (like buffer etc) THX....
  3. Admin Password Xp
    no admin pw for xp (5)
    Need some help or advice here please. Need to reinstall windows XP but have no Admin Password. I
    bought this PC used from a office that was getting rid of a few computers and such. Thing was, they
    did not give me the PW for the admin. I have called them to see if I could get it, but the I.T. guy
    is no longer with them, and they knew nothing about it. well now I must reinstall XP due to ad ware
    that has even trashed my anti virus programs and CC Cleaner. I had thought of maybe running down a
    password cracker but I used one in the past but did more damage than good. A....
  4. Softfuse Password Generator 1.4
    (1)
    Generate strong passwords for your accounts, e-mail client, or system. Click Here To Download ....
  5. Linux Anti-virus Software
    is it required? (6)
    Just installed Linux Ubuntu on a partition with Wireless access to the Internet and have a question
    about the need for an Ani-virus software. Is it suggested to have it installed? and which one is
    recommended by the Trap17 users? Ubuntu 8.04 installed via Wubi, if that matters. Both the LAN
    hard-wire connection and the Wireless Adapter work, if that matters.......
  6. Linux Kernel Problem
    (2)
    Hi members of trap17, I have a problem in the server that breaks my head for the past few days...
    Any help will be greatly appreciated. Thanks in advance Here is the problem Operating System:
    CentOS 5.0 kernel 2.6.18-8 Problem: journal commit I/O error Why this occurs: when we do some
    read write operations in our server, without any reason the entire file system goes to read only
    mode and all our future write operations fail.. and it spits journal commit I/O error Please
    explain as to why this error occurs and what can be done to resolve this issue.....
  7. Linux
    (5)
    I am thinking of getting Linux, but i'm not sure how compatible the programs will be between the
    two systems... I mean would i be able to read .doc and other MS documents? Could also Linux produce
    files with .doc extension because my school demands the docs to be only with this extension
    /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" />....
  8. Openoffice Worm Hits Mac, Linux And Windows
    (1)
    i found this on zdnet QUOTE According to the Symantec Security Response Web site, the worm is
    capable of infecting multiple operating system platforms and is spreading. The advisory said: "A
    new worm is being distributed within malicious OpenOffice documents. The worm can infect Windows,
    Linux, and Mac OS X systems. Be cautious when handling OpenOffice files from unknown sources". In
    an interview with ZDNet Australia on Thursday, Dr Jan Hruska, who co-founded rival antivirus firm
    Sophos and was one of the first ever PC antivirus experts, said that Apple Mac's ....
  9. Bbc Iplayer
    Linux and Mac Ignored (3)
    The BBC are developing a piece of software called iPlayer, that will allow people who hold a TV
    Licence to watch brodcasts up to 7 days after their original transmission by downloading them
    through the BBC's software. This is a great idea, and shows the BBC are competing with the likes
    of Channel 4's On Demand service. It'll be free, and they've worked hard with the owners
    of the programmes to make sure they can bring as much as possible to the service. However, there is
    a major problem: iPlayer will require Microsoft Windows and Internet Explorer. The BB....
  10. Linux On Old Computer
    (2)
    Is there any distro of Linux that would run on a computer with 32MB RAM and 10gigs hard drive? I
    want to experiment with Linux before trying it on my current computer. Thanks to those who answer in
    advance.....
  11. Adobe Acrobat File Password
    (1)
    I have done a work with Microsoft Word then exported it to a PDF File and deleted it.. the problem
    that I have made a security password to that pdf file last month but I forgot it now.. please tell
    me if there is a software or a way to recover or disable my password ? /sad.gif"
    style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> ....
  12. Got My Linux Browsing Now
    (1)
    Hey everyone, I have been scavenging my newly installed Linux OS - PCLinuxOS for a way to get it to
    start browsing. You know what? this thing has been giving me hellmformsome days now cos no matter
    what I do, it just wont browse or connect to any local area network. But now, I have been able to
    do that without consulting anyone. Well I can only say that I am happy for been able to get it to
    start working.....
  13. Having Problems Installing Apache2 On Linux
    Any tux lovers to help me out? (3)
    I am installing Apache 2 on Ubuntu Linux 6.06 (downloaded appropriate binary), and have followed the
    instructions from several places, including apach.org... I have got to the point where it says to
    enter make , just after the ./configure --prefix=/usr/local/apache2 , where I also added
    --enable-mods-shared=most , for the common options. That all went fine, took a little while, then
    when it's done I am supposed to enter make , I presume to gather up all the newly created
    files. This command just does not exist. returned bash error and it is not in the manual.....
  14. Random Password Generator (updated With New Features)
    Program I Made For Passwords (10)
    Well I got bored last night during the 6 hour trip from New York to New Hampshire so I decided I
    mine as well make a program I could use. (Although I started it in last 20 minutes of ride). Anyway
    I created a Random Password Generator that allows you to choose how many characters long you would
    like it to be, and it will create a password of numbers, letters (upper and lower case) of however
    long you would like. It then has a copy and paste button. Please tell me what you think. By the
    way this is only for windows. Of course this probably has been done but oh well. ....
  15. Good Php, Mysql, Perl, Postgresql, Html, Css Etc For Linux?
    Going to the good side, but dont really feel like emulating ZDE... (2)
    Im going over to the good side, (getting Ubuntu next Monday), and need a good PHP++ editor for
    Linux. There are just so frikken many out there that it is scary. Prefferable with minimal HTML
    WYSIWYG editor, and parsing preview (similar to what ZDE has, maybe?) Anyone got any Ideas to share
    with a n00b? I feel very small at the moment /sad.gif" style="vertical-align:middle" emoid=":("
    border="0" alt="sad.gif" /> And no, it will be running most of the day, so dont say to emulate
    some window thing... /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" a....
  16. Look Out Linux Fans Ubuntu Is Comming Out On June 1st
    get ready to grab your own copy (1)
    UK-based Canonical Ltd. will introduce all-new versions of its popular Debian-based Linuxes --
    Ubuntu, Kubuntu, and Edubuntu -- along with its first enterprise server edition on June 1, a company
    spokesman told DesktopLinux.com May 25. The full release of Ubuntu 6.06 -- code-named Dapper Drake
    and featuring the latest GNOME desktop -- includes both installable live desktop CDs and text-mode
    install CDs for three architectures. Canonical will mail free CDs upon request beginning June 1, the
    spokesman said. Kubuntu is based on the same Debian-powered core as Ubuntu, but ....
  17. Suse Linux 10.1
    (3)
    Suse 10.1 is finally out after a long period of beta testing. For those who don't know what Suse
    is, Suse is a linux operating system. 10.1 is supposed to fix all the problems of suse 10 and also
    include a new package management system. A commercial version of Suse 10.1 is released and their is
    also an open source version called openSuse 10.1 that you can download for free. Suse is by the way
    one of the best linux distributions ever, and thats just an opinion, but a fact. Suse is right with
    RedHat linux, which is the leader in the linux world. Suse 10.1 has many new ....
  18. Itunes On Linux
    (0)
    Do you like iTunes? Are you a Linux user? If yes, then you would want to hear about this. There
    is a petition posted on the internet that is trying to get signatures to present o Apple that
    porting itunes and itunes music store is a good idea. The creator of the petition think it will be a
    success, because Apple is open-source friendly. So if you want to get iTunes on linux sign this
    petition, you don't need a pen, just type your name and check yes to have itunes on linux.
    Here is the link to the petition: http://www.petitiononline.com/itmslin/petition.htm....
  19. Linux Question: Amarok And File Permissions
    please help, i can't get it to work with all music files (4)
    hey, i use to use Linux DC++ to download music from some hubs and i usually download it to
    /home/downloads/ and then i move the files to my collection on another HDD a sata one, on
    sda3/music/ but when i move the files using krushader root mode they become posessed by root and
    amarok can't play them displaying a locker on the file's icon. I tried to " chmod 774 music
    ", where music is my music directory, as root in konsole but no luck. What should i do to make a
    whole directory accessible from amarok as user?....
  20. What Firefox Extensions Should I Install To Get My Firefox Mimic Opera?
    It's only because i use linux and opera hasn't sound in flash (4)
    Ok, hey guys first, i use linux and i have opera, konqueror and firefox installed and i didn't
    managed to get sound in flash websites in the first 2. So i could swich to firefox but i badly need
    autosave sessions on close, and mouse gestures -how can one live without them. Any other good
    extension for firefox that u know and it's of great use? And how does extensions install?....
  21. Windows Admin Password Hack
    (4)
    Windows Admin Password Hack: Forgot your NT admin password? Reinstall? Oh no... But not any more...
    This is a utility to (re)set the password of any user that has a valid (local) account on your NT
    system. You do not need to know the old password to set a new one. It works offline, that is, you
    have to shutdown your computer and boot off a floppydisk or CD. The bootdisk includes stuff to
    access NTFS and FAT/FAT32 partitions and scripts to glue the whole thing together. Will detect and
    offer to unlock locked or disabled out user accounts! It is also an almost fully func....
  22. Call For A Tlug?
    How about a Trap17 Linux Users Group? (0)
    I have something that might be a bit of an idea, thought I'd share it so I know if it's a
    good idea or a bad one. I get the feeling (upon having browsed a few forums around here) that a lot
    of Trap17 members are also users of linux. Not necessarily passionate, anti-every-non-unix-OS users,
    or potential kernel hackers - just balanced and normal, every-day linux users. So I was wondering if
    we could have a separarate sub group called the Trap17 LUG, perhaps a new board or a plain mailing
    list - to discuss Linux and related issues. Obviously, every member of Trap17 ....
  23. Forgot Password To Trend Micro Internet Security
    Is there a way to remove it? (8)
    One day I was bored so I set a password for our Web security software, Trend Micro Internet
    Security. I turned on the URL filter, and now, whenever my friends send me something funny that has
    no porn or anything in it, I get the Blocked error. I am really annoyed by this; I can't change
    other setting in the software too. Is there any way to either reset the password or remove it,
    without uninstalling Trend Micro?....
  24. Installed Xampp, But ...
    there are a couple of problems with my Install. (3)
    Thanks to the tutorial here at the Trap17, I decided to install a copy of XAMPP on my Windows 98
    Laptop so I could learn some more php coding without crashing the server on the Forum here. The
    Tutorial was good, it helped a lot, but there are two things which I need a hand with. Both
    problems might be Browser related, but I don't know, so here is the first problem: First
    Problem Opera can't find the Local server. I have a test file or two which run perfectly in
    the Firefox Browser, but if I Cut and Paste the address into the address bar of Opera 8, I get a ....
  25. Password Protecting A Flash Drive
    AKA A USB Memory Drive (8)
    Ok, well i bought this Flash Disk and it is basicly a portable memory stick that you can plug into
    the USB Drives of computers, and i have stuff on there i want protectd, and i waswondering if anyone
    knows of any software that i can put on there to pasword protect EVERYTHING that is in the drive,
    for example when i open the drive it required me to type a password in, any help would be much
    appreciated thanx! i have not been able to find one and i have been searching for a while....
  26. Help With Linux Ubunto Os
    Tutorial for linux ubunto (14)
    I've got a copy of linux ubunto but don't how to use it, /sad.gif' border='0'
    style='vertical-align:middle' alt='sad.gif' /> I don't have any idea about this kind of OS yet,
    is there any body knows a site that offers free tutorials for linux ubunto? I really appreciate if
    you can help me with this.. /biggrin.gif' border='0' style='vertical-align:middle'
    alt='biggrin.gif' /> ....
  27. Linux® Trademark?
    (3)
    http://www.linuxmark.org/ QUOTE The registered trademark Linux® is used pursuant to a license
    from Linus Torvalds, owner of the mark in the U.S. and other countries. What's going on
    here? It seems that Linus Torvalds (the creator of Linux) realised that he can make some cash with
    his creation - actually, it's NAME! Linux is now a registered trademark, and you must pay (
    http://www.linuxmark.org/fees.html ) in order to use it in your distribution name! QUOTE As
    stated in our articles of incorporation, The Linux Mark Institute ("LMI") is an orga....
  28. Linux Under Windows
    Linux in windows (19)
    Do u want to run linux with out uninstalling window or without dual boot? Here, is the little
    utility "Linux under windows". Download from "Mainsoft". It is cool ... Try out today. ....
  29. Proftpd Ftp Server In Linux
    how to configure it? (1)
    Hi, I just installed the ftp server proftpd in my linux machine. I executed it and i can login it
    with my user. It redirects me to my /home/myuser. Until here everything ok. My idea was configuring
    a ftp server where a predifined user could access only a folder's range with read only
    permisions and also a folder with write permisions but not read permisions. I am not sure about the
    steps to follow to do this. So i thought that maybe someone in trap is using proftpd and could help
    me. So the steps will be: - Create a user with the command useradd/passwd - Modify the ....
  30. Windows -> Linux
    Software comparison (17)
    For those who are planning to switch to linux, here is a fine comparison of software:
    http://linuxshop.ru/linuxbegin/win-lin-soft-en/table.shtml ....

    1. Looking for mysqls, default, root, password, installed, linux, box
Similar
File Manager In Puppy Linux
Media Player Linux
Admin Password Xp - no admin pw for xp
Softfuse Password Generator 1.4
Linux Anti-virus Software - is it required?
Linux Kernel Problem
Linux
Openoffice Worm Hits Mac, Linux And Windows
Bbc Iplayer - Linux and Mac Ignored
Linux On Old Computer
Adobe Acrobat File Password
Got My Linux Browsing Now
Having Problems Installing Apache2 On Linux - Any tux lovers to help me out?
Random Password Generator (updated With New Features) - Program I Made For Passwords
Good Php, Mysql, Perl, Postgresql, Html, Css Etc For Linux? - Going to the good side, but dont really feel like emulating ZDE...
Look Out Linux Fans Ubuntu Is Comming Out On June 1st - get ready to grab your own copy
Suse Linux 10.1
Itunes On Linux
Linux Question: Amarok And File Permissions - please help, i can't get it to work with all music files
What Firefox Extensions Should I Install To Get My Firefox Mimic Opera? - It's only because i use linux and opera hasn't sound in flash
Windows Admin Password Hack
Call For A Tlug? - How about a Trap17 Linux Users Group?
Forgot Password To Trend Micro Internet Security - Is there a way to remove it?
Installed Xampp, But ... - there are a couple of problems with my Install.
Password Protecting A Flash Drive - AKA A USB Memory Drive
Help With Linux Ubunto Os - Tutorial for linux ubunto
Linux® Trademark?
Linux Under Windows - Linux in windows
Proftpd Ftp Server In Linux - how to configure it?
Windows -> Linux - Software comparison

Searching Video's for mysqls, default, root, password, installed, linux, box
See Also,
advertisement


What Is Mysql's Default Root Password? - Just installed in on my Linux box

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com