Jul 20, 2008

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

Free Web Hosting, No Ads > CONTRIBUTE > Computers > Software

free web hosting

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?

Reply

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.

 

 

 


Reply

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

Reply

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

Reply

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

Reply

iGuest
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?

Reply

iGuest
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

Reply

iGuest
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

Reply

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’;

Reply



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*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. mysql default root password - 0.00 hr back. (3)
  2. defult password mysql - 1.07 hr back. (1)
  3. mysql default username and password - 1.27 hr back. (2)
  4. default mysql username password - 1.54 hr back. (2)
  5. mysql default password - 0.79 hr back. (3)
  6. mysql default user - 1.87 hr back. (1)
  7. mysqll default root password - 2.01 hr back. (1)
  8. default password mysql - 0.59 hr back. (3)
  9. default mysql user password - 2.43 hr back. (2)
  10. default mysql username and password - 2.81 hr back. (1)
  11. pclinuxos mysql daemon - 3.76 hr back. (1)
  12. default mysql root password - 4.11 hr back. (1)
  13. root mysql default password - 4.61 hr back. (1)
  14. appserv default mysql password - 4.78 hr back. (1)
Similar Topics

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

  1. Admin Password Xp
    no admin pw for xp (5)
  2. Softfuse Password Generator 1.4
    (1)
    Generate strong passwords for your accounts, e-mail client, or system. Click Here To Download ....
  3. 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.......
  4. 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.....
  5. 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" />....
  6. 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 ....
  7. Bbc Iplayer
    Linux and Mac Ignored (0)
    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....
  8. 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.....
  9. 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" /> ....
  10. 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.....
  11. Having Problems Installing Apache2 On Linux
    Any tux lovers to help me out? (2)
    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.....
  12. 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. ....
  13. 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....
  14. 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 ....
  15. 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 ....
  16. 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....
  17. 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?....
  18. 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?....
  19. Windows Admin Password Hack
    (1)
    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 ....
  20. 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 ....
  21. Forgot Password To Trend Micro Internet Security
    Is there a way to remove it? (5)
    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?....
  22. 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 ....
  23. Password Protecting A Flash Drive
    AKA A USB Memory Drive (6)
    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....
  24. Ati V8.21.7 Display Drivers For Linux
    new fresh release (1)
    ati's released just a few moments ago a mentenance release of their drivers and Phronix has
    comented upon it and made a few tests with the linux drivers.Check it out on:
    http://www.phoronix.com/scan.php?page=article&item=372&num=1 Cheers!....
  25. Error In Linux ,please Help
    (4)
    hy folks, i recently installed some kde-based linuxes and get this error quite frequently not onli
    at mepis- which i am running now. It appears when starting kde with the bootsplash showing the start
    of the few kernel components at the very first one called "Setting up interprocess communication".
    Behind it, in an alert window sais: "there was an error setting interprocess communication for
    kde.The message returned by the system was: Could not read network connection list.
    /home/realthor/.DCOPserver_mepis_workbox_0 Please check that the dcopserver program is running!....
  26. Ati Petition For Adequate Drivers In Linux
    Let's all give a hand here (7)
    Whether you're a Linux fan or just interested in open-source software and free OSes that can
    spare you lots of money than helt Linux get better and sign this petition ; it asks just for an
    e-mail adress and a name. There are already 23,249 signatures so let's put together some
    pressure on ATI to release better linux drivers so that , beoming better and more widely used, the
    game manufacturers and others will reconsider and write games and applications for linux as well.
    The adress goes like this: http://www.petitiononline.com/atipet/petition.html ....
  27. Help With Linux Ubunto Os
    Tutorial for linux ubunto (13)
    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' /> ....
  28. 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....
  29. 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. ....
  30. 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 ....

    1. Looking for mysqls, default, root, password, installed, linux, box

Searching Video's for mysqls, default, root, password, installed, linux, box
Similar
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
Ati V8.21.7
Display
Drivers For
Linux - new
fresh
release
Error In
Linux
,please Help
Ati Petition
For Adequate
Drivers In
Linux -
Let's
all give a
hand here
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?
advertisement



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



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE