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
ADVERTISEMENT
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
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
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
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
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
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
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
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
View Related
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
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
Jul 1, 2011
i booted into linux single mode thru lilo but i can't use any commands in slackware that changes the root account or user account using passwd root command
View 1 Replies
View Related
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
Aug 10, 2010
I'd like to keep root pw==sudo pw==user pw on a box with Code: $ lsb_release -ds Ubuntu 9.10 $ uname -rv 2.6.31-22-generic #61-Ubuntu SMP Wed Jul 28 02:02:56 UTC 2010 Just now it hung going to sleep, so I shutdown via BRS. On cold boot, HD mount failed and I got the prompt to hit Esc to goto maintenance shell. I did that, got the prompt for the root password, and entered my sudo.
That failed! though it has worked before ... but I changed my user password on that box recently, and I'm pretty sure I haven't needed to fsck between then and now. I'm wondering: What do I need to do to set my root pw? I was able to C-d out of the shell, and karmic took care of itself, but I'd prefer not to rely on that. Is there a way to make my root pw always equal my user pw? If so, is that a Very Bad Idea?
View 2 Replies
View Related
Dec 11, 2010
I'm running an Ubuntu 9.04 Minimal server and trying to get MySQL to work correctly. But when I try to access MySQL with the root user it doesn't want to.
Code:
mysql -u root -p
Enter password:
[code]....
View 4 Replies
View Related
Jun 26, 2011
how to implement a password login system that both sends passwords over the internet in an encrypted form (so my users don't get that annoying message saying "this web site is about to send your password in an unsafe form..." and stores its user data in a MySQL database? This seems to need a combination of mod_auth_digest and mod_auth_mysql.
View 1 Replies
View Related
Mar 12, 2010
how to find the root password on Server 9.1
View 2 Replies
View Related
Feb 4, 2010
I am trying to set up a webserver with apache, mysql and php on a old pentrium 4 computer. When I tried to setup my MySQL password, I created a password with punctuation in it. MySQL didn't want the password and gave some error about BASH. I tried changing my password again but now I constantly get the error that I am unable to login. I tried all the possibilities with the password I entered before but i just can't login to MySQL anymore. I found some help sites on how to reset your password by running MySQL in the safe mode but that didn't work for me. Can anyone help me resetting my password? Next time i'll use a pass without punctuation Every help is much appreciated! BTW, I also tried uninstalling MySQL with yum (yum remove mysql) and it uninstalled, but when I installed it again the password was still there
View 4 Replies
View Related
Aug 31, 2010
I have one of those ultra reliable Ubuntu servers in the corner that I never have to logon to because it never needs anything. I needed to check up on it today and my root password would not work. I am absolutely sure I did not forget my password and because I am the only Linux guy in the office I am sure some nimrod didn't get his fingers in the machine. I attempted to enter GRUB recovery mode but when I hit ESC it says something about no disk and goes into the booting process. I attempted to use a desktop version live CD, but the file structure is unreadable, I assume due to the security of the server system. Before I rebooted it the server worked fine, Apache and PHP were working away. Now the whole thing is a 50Lb boat anchor. How can I reset the password when I cannot enter GRUB menu or use a live CD?
View 9 Replies
View Related
Mar 20, 2010
So i have a fresh install of the server edition of Karmic, i'm running the Xfce desktop. When I attempt to manage users and groups through the GUI, I am prompted for what I think is the root password, the reason I say this is because the account I am currently logged in has sudo privileges and it does not accept that password at all, but I read that by default the root account is 'locked,' (to be honest it was so long ago since I last installed Ubuntu I completely forgot if it is or isn't, my current desktop installation has su access) is it asking for the root password? why doesn't my current user account password work if the root account is 'locked'? I can perform all other administrative tasks with sudo no problem.
the funny thing is, I have the exact same setup in a virtual machine, the same problem happens, except for some strange reason after changing the password on the only account (besides root), the password required to administer users and groups stayed the same after the change. (at the time of installation I just put both the user and root password the same and now that it is setup), i'm now ready to change the passwords. except now I read that the root account is locked by default, but this strange problem occurs.
View 2 Replies
View Related
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
May 21, 2010
I've setup an openldap server, and am trying to add .ldif files to the database.
I am constantly getting the following error, no matter what I do:
View 18 Replies
View Related
Dec 14, 2010
I have installed mysql-server, but i have no access. I have set the password during installation process.
Used command:
mysql -u root -p
error message:
[code]....
View 8 Replies
View Related
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
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
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
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
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
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
