Software :: Can't Setup MySQL Root Password?

Aug 1, 2010

Following guide for CentOS 5.5 i've installed mysql server on my box.Next step was setting up password for root user.As you undestood, it failed. output:

Code:
# rpm -qa | grep mysql
mysql-devel-5.0.77-4.el5_5.3

[code]....

View 1 Replies


ADVERTISEMENT

Ubuntu Servers :: Setup The MYSQL Server - Error: 'Access Denied For User 'root'@'localhost' (using Password: NO)'

Mar 26, 2010

I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-

Quote:

root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Query :-

1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).

2) Is there a way to

a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working

(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)

Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)

View 4 Replies View Related

Server :: How To Reset Root Password Of MySQL?

Sep 21, 2010

for resetting the root user's password. Actually, I am using www.linuxzoo.net for online practice of Linux and have MySQL installed on it. But I forgot the password I set. There was no password by default set for the root user. So, I just trying setting a password last week. Now I am not getting what I did.

View 13 Replies View Related

Software :: Remove The Root Password In Mysql?

May 28, 2010

is there any way to remove the root password in mysql,if can what is the command to remove it.

View 3 Replies View Related

Ubuntu Servers :: Reset MySQL Root Password

Sep 7, 2010

I have forgotten my root password for MySQL, what can I do to recover it, I've found a few guides but they don't work on the newer versions of Ubuntu.I am running on Ubuntu 10.04 server so MySQL is an upstart job so the methods I've seen with launching it without the access checks haven't worked for me

View 4 Replies View Related

Ubuntu Servers :: Trying To Reset Mysql Root Password

Oct 14, 2010

I have forgotton my root password for mysql. I followed some instructions on a website and now I am not sure what i have done?Basically, when I now try and start mysql I get a notification that i have converted the init script to an upstart. I dont know what this means.

Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the start( utility, e.g. start mysql mysql start/running, process 20301.

View 1 Replies View Related

Ubuntu :: Install Mysql Without Setting Root Password

Dec 28, 2010

Is there any way i could install mysql without setting the password for the root account during installation? preferably using the command line.

View 4 Replies View Related

Ubuntu Servers :: Setting Root Password In Mysql?

Aug 19, 2011

Using 11.04, and just installed mysql 5.1.54 using synaptic

I was following the instructions here and the installation when fine,

except that I never got a screen to set the root password.

When I try to set the password using these instructions, following either

"If you have never set a root password for MySQL" $ mysqladmin -u root password NEWPASSWORD

OR, since the first method failed me, then: "However, if you want to change (or update) a root password, then you need to use following command" $ mysqladmin -u root -p'oldpassword' password newpass

Either way, it fails. Question:

1) why am I not being prompted to set a root password during installation?

2) what can I do now to fix this??

I am trying to learn Mysql, so don't presume I know anything about command syntax (cookbook instructions) For example, the first command above,I tried with with NEWPASSWORD in quotes, and then without. Likewise for the second command.

View 9 Replies View Related

CentOS 5 :: Installing HORDE /IMP - Use The MySQL Root Password ?

May 25, 2009

To install horde/ imp. I found this page : [url]

I get stuck at the part where it says Youll need to use the MySQL root password. Then, in your database administration screen for MySQL, set the password for the new MySQL user horde to something nicely random and hard to guess; keep a momentary record as youll need it below.

It is really frustraing to get stuck at something so simple as installing horde imp on centos. how to get it installed on a CENTOS 5.x system ?

View 1 Replies View Related

Fedora Installation :: Change The Root Password Of MYSQL Server

Mar 16, 2009

How can I change the root password of MYSQL server. I have just finished installation, but I mistakenly typed the wrong root password, and now I need to change it from command line, because I cannot even access the UI.

View 8 Replies View Related

Ubuntu Servers :: Mysql Root Password Reset Hangs?

Jul 16, 2011

I forgot my root password for mysql, and after some searching I found several solutions to fix it. But none of them seem to work.I tried this article http://ubuntu.flowconsult.at/en/mysq...root-password/ with starting mysql with the --skip-grant-tables option. The problem is that nothing happens, it just hangs.Also tried the the --init-file option, that one runs fine, at least it returned to the command line. But the sql query in the file to which it point doesnt seem to do anything. The password wasn't changed to the one I specified in the sql file.Any idea what could be going on here, and how I could fix it?

View 3 Replies View Related

Fedora :: Setup 12: What Password For Su Root

May 5, 2010

I am trying to su from liveuser to root to run yum update. If I am not root, I get a message that says "need to be root to perform this command". I am logged in as liveuser. If I do an su root then it says that my password is invalid. Since I did not set up the root user, I do not know the password.

View 6 Replies View Related

Ubuntu :: How To Setup Root Password

Oct 8, 2010

I just installed ubuntu. How do I set up my root password it didn't prompt me in the setup.

View 9 Replies View Related

Slackware :: Can't Create Root's Password During Setup

Jan 3, 2011

I download DVD ISO image of slackware 13.1. I check md5sum of the image. It is correct. I install the OS on my computer. During Setup, I can't create root's password. I try to input new password when prompt. And I retype the password for confirm. But the error show that "They don't match ; try again."

View 6 Replies View Related

CentOS 5 Server :: Mysql-server How To Setup Password

Aug 30, 2009

i try to install mysql-server how do i create a password for it

yum install mysql mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.optus.net
* updates: mirror.optus.net

[Code]...

View 1 Replies View Related

OpenSUSE Install :: Root Password Not Set \ Wasn't Prompted To Set The Root Password?

Jun 25, 2010

When I installed the OS, I wasn't prompted to set the root password. Is this a bug, or did my install hose up?

View 4 Replies View Related

General :: Mysql Not Starting After Changing Mysql Admin Password In Fedora?

Feb 19, 2010

Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.

View 1 Replies View Related

General :: Interact With The Mysql To Reset The Root Mysql Pass?

Jun 14, 2011

I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now

Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt

[Code]...

View 6 Replies View Related

General :: Mail Server : Reset The Password For It Using The Password Command From The Root Login?

Jul 23, 2009

I am an absolute Linux Beginner who is being required to do a bit of admin work because the boss just fired the old linux admin. Unfortunately, one of our employees cannot remember her password to her email account and as such I need to reset it on our linux server.What I want to check is that this email account is actually a linux user account and I simply will reset the password for it using the passwd command from the root login. Is that correct?

View 1 Replies View Related

Ubuntu :: Password Overwrite - Root Access Is Destroyed - Restore The Password File?

Mar 3, 2010

I m Trying to get vsftpd usergroups to work i accidentally moved a file called passwd from /etc/vsftpd/ to /etc/, resulting in my root access is destroyed! how to restore the passwd file so i can keep working, or do i have to re-install the entire box?

View 4 Replies View Related

Ubuntu :: Change Root Password - Typing A Password, No Characters Show Up?

Mar 9, 2010

I'm really new to Linux so this will probably sound like a pretty naive question to most users, but how do you change the root password?To install Java, I have to type # su into Terminal,which then asks for the password.What's weird is that when I start typing a password, no characters show up. I don't know if this is supposed to happen or not.I've found a bunch of different sites on the Internet that explain how to change the root password, but none of them seem to work for my specific work station.

I've got Ubuntu 9.10 64 bit. In the GRUB boot menu, I can choose to boot normal or in recovery mode (I'm led to believe older versions don't have this option).I've tried typing # sudo passwrd into Terminal, but I already have a root password set up apparently, so I can't change it there.

View 4 Replies View Related

Red Hat / Fedora :: Recover User Password And Root Password If Forgotten ?

Oct 24, 2010

How to recover user password and root password in fedora if u forget

View 2 Replies View Related

Server :: Setup Master / Master Mysql In HA Setup Without Use Of Load Balancer Provided By Host?

Mar 31, 2010

I have a load balancer with 2 web servers behind it. The web servers rsync with cloud storage to update their apache directories 1 time every hour. Apache is just running php pages that pull/push data to a DB so they dont need to be updated that often. However I need to figure out how to implement a Master/Master MySQL setup to have my web servers point to for the PHP stuff. I need to implement it without having a single point of failure. The Load balancers are useless for failover as they only detect availability based on Ping request. So putting a master/master setup behind a Load Balancer is out. what is the best way to setup the master/master mysql in a HA setup without the use of a load balancer provided by the host?

View 2 Replies View Related

Ubuntu :: Root User Directory Does Not Exist, Root Password Not Recognised?

Oct 26, 2010

I no longer have access to my root desktop. On a session I attempted to change the root username but i apparently assigned it a wrong directory that does not exist. When I rebooted with my new root username, i was instead recognised as a simple user (no root privileges). I tried the console to change to "old" root but root password is not accepted and there is no way to access to sudoer files. it seems that inserting a new username requires root privileges and i am back to square one. Simply logging with old root username and password after restart gives me a blank screen with nothing on it and cannot even reboot.

View 9 Replies View Related

General :: Did Not Find Any Option For Root Password For Root User In Ubuntu 9.10?

Mar 2, 2010

i used opensuse 11.1 ...there is option for root user to create password for root...but for ubuntu i did not find anything like that...so how can i create root password....or how can i use root

View 1 Replies View Related

General :: CentOS / Sudo Doesn't Accept Root Password But Logging In As Root Works

Apr 9, 2010

I was trying to edit a file requiring root permissions, so I used sudo. I typed the root password and it failed. This happened three times, and the process was ended. I then logged in as root (su) and was able to navigate to the file and make changes as root. Am I missing something? How would I edit the sudoers file such that this password would work? Or is there another way to log in to the sudo group to make these changes? How do I set sudo passwords?

View 1 Replies View Related

General :: Forgot Root Password And How To Change The Password

Jul 2, 2010

i forgot root password and how to change the password

View 3 Replies View Related

Red Hat :: Cannot Change Root Password (let Alone Standard User's Password)?

Jan 6, 2009

At the RHEL prompt, I entered the standard user's username/password combo. Linux displays a message box stating:"Your account has expired; please contact your system administrator."Next, I entered "root" in the username field and entered the root password (which expired also--keep in mind that passwords are set to expire after x days). Linux displays a message box stating:"You are required to change your password immediately (password aged)."When prompted to "Enter current UNIX password", I entered the new password (was that the right thing to do?); Linux displays a message box stating:"The change of the authentication token failed. Please try again later or contact the system administrator."I rebooted the system and got into command line mode; somehow I logged in as "root" (don't know exactly how, but needed to change the password there). At the "#" prompt, I type "passwd root"; Linux displays the message "Changing password for user root", followed by the message "passwd: Authentication information cannot be recovered.

View 4 Replies View Related

Debian :: Root Login Without Setting Root Password

May 14, 2015

I edited fstab to automatically mount my windows data partition on boot, but I screwed it up by not specifying the file system type, however that is not the problem, I was able to fix that easily. The problem was that when it failed to mount the partition, Debian automatically entered root and I guess that is to be expected in order for me to fix it, but I never configured a root password and it just gave me full root access without asking any password, not even my user password. I though that was strange so I set the root password and sure thing it asked me for the root password this time without automatically logging into root....

I then tried to lock the root account to see if it will ask me for a password or not, it did but of course I wasn't able to login as root because it was locked now and I was left with no way to access the system. I had to fix fstab from a live cd so that I can login normally as the user....

I didn't know what to search for or if that is the expected behavior if you don't set root password during installation, but it just seemed a bit strange to automatically enter root when you specifically disable root login during installation...

View 1 Replies View Related

Ubuntu :: Root-User : Unset The Root Password?

Oct 14, 2010

A friend of mine has told me to set a root password and use root (f.e. switching to su in terminal and work with root rights instead).Is there any way to unset the root password? I know how to use sudo now.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved