Need to Delete ROOT Account!

Posted on 2006-05-25
Last Modified: 2012-05-05
Hi experts,

I have Mandriva 2006 with Apache,PHP,MySQL and IPB.

I have forgotten my SQL login credentials, can i delete them somehow without logging in to SQL as i cannot do that.

the error it gives is:

When i type mysqladmin -u root password 'mypassword' it says:
"mysqladmin: Connect to server at 'localhost' failed
error: 'Access Denied for user 'root'@'localhost' (using password: NO)'

Any ideas??

Thanks in Advance,
Question by:deathw4r3z
    LVL 6

    Expert Comment

    it appears you are using a wrong syntax for connecting to mysql.

    mysqladmin -u[username] -p[password]

    and make sure there is no space between -u and the username and -p and your password.
    LVL 12

    Accepted Solution

    huh? at least mysql.exe for mysql4 wanted spaces. when i want to login, i always do it this way:

    mysql -u root -p
    [enter] and then it asks me for the password. this is a bit more secure, as the typed in text wont be displayed. also the message above states "... (using password: NO)", so it didnt detected that youre giving a password. try it like ThomasFranke said, then this way here :P
    LVL 6

    Expert Comment

    This is a correct syntax for logging mysql server :

    >>bin>>mysql -u root -p

    Warm Regards,

    Vipin Gupta

    Author Comment

    Sorry, How do i make Assisted Helpers etc,

    Because i wanted to split the points between all of you, seeing as you all helped me.

    Can an Admin do that plz,

    Thanks in Advance,
    LVL 12

    Expert Comment

    at the links above, click on "support". post a question there to re-open this thread. give a link to this question, so the admins know which thread to re-open. explain it like "misselected answer" or something.

    then you can give points again. but dont click anywhere on "accept" then, click only (i think its quite at the bottom" the link "split points". then you can give each post an amout of points youre thinking of - only make sure that they will sum up to the ones you have awarded here. then i think you can additionally mark some post as "accept". the other ones automatically become "assisted".

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now