Ubuntu :: Mysql Errors Can't Logon As Root?
Jan 11, 2010
I went away this weekend and everything with my mysql server was working great. I got home on sunday, and I found that my web pages couldn't be displayed because they were unable to gain access to the mysql database.
I am now not able to log into mysql using root or debian-sys-maint. I get error messages.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I have tried loading mysql in safe mode, and changing the passwords, but this does little to help me.
I am unable to retart my services without them failing, so after making the changes i have to manually kill the processes for mysql to get it to stop. After doing that i try to start mysql up, and it gives me a .sock error. I will post some of the errors in my next post, but if anyone has a general idea what i can try to manually override the passwords or reset them. I did read that i can reset the debian-sys-maint password using the msql/rm.conf , but i am unable to log on as root to change the password
View 2 Replies
ADVERTISEMENT
Aug 11, 2009
I'm running Suse 11.1. MySQL is installed. I downloaded and installed the software for MySQLAdmin and MySQLBrowser, this was one software package so both got installed at the same time. My question is this; When I log into MySQL to use the Admin Tools it doesn't like my root password. So I log in as 'localhost' with the id of 'root' and no password and I get right into the main Admin menu. Why doesn't it accept the root password and how can I change the root login to need to have a password. Will just changing the password in MySQL Admin do the trick?
View 5 Replies
View Related
Mar 5, 2010
after doing a partial yum update and configuring cyrus and installing splunk my server box is not logging in to any of the users i have setup on it.to setup the cyrus server i used pam authentication so my assumption it could be that or somthing with the splunk install which i left default to /opt/.im running an old kernel i think its fc11 29 .pae in my boot logs i dont see that anything failed to run but it still does't let me logonk
View 2 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
Nov 25, 2009
All of these audit messages is from one su - and root password at a gnome-terminal.This started happening from some update from koji in the last 18 hrs or so.It take 20-25 sec from su - to get the password prompt.
[Code]...
View 2 Replies
View Related
Jan 26, 2010
Our system is based on RH4 and is using pam_tally and faillog to record failed attempts and to lock users out after 5 attempts. We have a requirement to provide a normal (non-root) user logging onto our system, with information regarding the number of failed logon attempts made on their account before the current successful logon (similar to the functionality provided by HP Protect Tools on Windows). My first idea was to add 'faillog -u $USER' to the bashrc, however by the time the bashrc is run - the user has been successfully authenticated and the faillog has been reset back to zero.
View 5 Replies
View Related
Jan 15, 2010
My mysql server won't start on my machine. It simply fails with no errors.
Code:
sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
When I run cat /var/log/mysql.err the file is empty, thinking this might be a permissions issue
I tried chowning to a mysql user. Here's the current permissions.
Code:
ls -alh /var/log/mysql*
-rw-r----- 1 mysql adm 0 2009-09-30 11:08 /var/log/mysql.err
-rw-r----- 1 mysql adm 0 2010-01-15 09:07 /var/log/mysql.log
-rw-r----- 1 mysql adm 20 2009-11-25 07:35 /var/log/mysql.log.1.gz
-rw-r----- 1 mysql adm 20 2009-11-24 07:59 /var/log/mysql.log.2.gz
-rw-r----- 1 mysql adm 20 2009-11-23 07:56 /var/log/mysql.log.3.gz
-rw-r----- 1 mysql adm 20 2009-11-22 07:54 /var/log/mysql.log.4.gz
-rw-r----- 1 mysql adm 20 2009-11-21 07:47 /var/log/mysql.log.5.gz
-rw-r----- 1 mysql adm 20 2009-11-20 07:43 /var/log/mysql.log.6.gz
-rw-r----- 1 mysql adm 20 2009-11-19 07:35 /var/log/mysql.log.7.gz
/var/log/mysql:
total 8.0K
drwxrwsrwx 2 mysql adm 4.0K 2009-09-30 11:08 .
drwxr-xr-x 16 root root 4.0K 2010-01-15 10:24 ..
Still having the same issue, mysql server is still failing and /var/log/mysql.err is still empty.
View 3 Replies
View Related
Aug 4, 2011
I am new to ubuntu. I want to start mysql but its not working! error occurs!
"
root@drazer-GA-MA785GM-US2H:/etc/init.d# mysql.server start
mysql.server: command not found
root@drazer-GA-MA785GM-US2H:/etc/init.d# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@drazer-GA-MA785GM-US2H:/etc/init.d# mysql start
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@drazer-GA-MA785GM-US2H:/etc/init.d#
"
I have installed mysql client and server packages.
View 4 Replies
View Related
Feb 23, 2011
I have just complied Snort 2.9.0.4 under Ubuntu 10.10 x86_64 installed with all Lamp package.The syntax i used to compile Snort as follows below
[Code]...
View 2 Replies
View Related
Feb 10, 2010
I am reading Sams Teach Yourself SQL in one hour a day. In this book they work with both Oracle and MySQL to teach you SQL. So I installed mysql on my box and I am creating the empty database they use in this book so I can follow along as I read. I have noticed a few typos in the book and now I have noticed some code errors too. I just don't know enough to fix em. I am working on creating the empty database and I am getting syntax errors when I create certain tables. I have checked both the printed version of the book and the electronic version (which differ slightly) and both give me the same synatax errors. First is Creating the first table of the database. Here is the code given to me to enter. The Electronic version
[code]...
how I can correct this error and create these tables?
View 5 Replies
View Related
Jul 14, 2009
I am trying to modify the source code of a C application (quagga) in order to insert data into a mysql table. I have added 2 new source files to the source (neto_mysql, neto_trend) which in turn use mysql.h. I have also modified the Makefile.am file to include the /usr/include/mysql directory.
When trying to compile, i get the following error. What am I missing? I have minimal experience with formal C applications like this. I feel like I may also have to include the mysql.h file in the libbgp? I dont understand why it cant find the mysql functions...
Code:
if gcc -DHAVE_CONFIG_H -DSYSCONFDIR="/usr/local/etc/" -I. -I. -I.. -I.. -I.. -I../lib -I/usr/include/mysql/ -fPIE -Os -fno-omit-frame-pointer -g -std=gnu99 -Wall -Wsign-compare -Wpointer-arith -Wbad-function-cast -Wwrite-strings -Wmissing-prototypes
[code]....
View 12 Replies
View Related
May 6, 2010
Just had a new VPS installed running Ubuntu Server 8.04 Getting some errors when I connect to the server and try to use apt.. only trying to install nano and after messing around I've managed to get the error to change.. but still can't get any further.
error
Code:
# sudo apt-get install nano
Reading package lists... Done
Building dependency tree
Reading state information... Done
[code]....
View 4 Replies
View Related
Apr 11, 2011
I installed MySQL and I started playing around (first time using a database).
I eventually ended up deleting the root user. And now I can't log back in.
I tried
Code:
And I was prompted to set a new root password, which I did. However...
Code:
I want to do a fresh install of MySQL.
View 2 Replies
View Related
Mar 25, 2010
I am having problems with an old laptop I have. It had windows xp on it, and after loaning it to a friend it wouldn't boot up. I decided to try linux, but I'm having problems loading it. If I try to run the liveCD it halts because its unable to mount root. If I try to install it just doesnt work well (will stop at different points).
So I figured a mem test would help. I am running the test, currently its on test #6, but it is coming up with a ton of errors. Does this mean I need to replace the RAM?
If so, this is the computer I have. Will this RAM work? I've been out of the tech game for awhile so not really following hardware anymore, and just want to double check.
View 5 Replies
View Related
Oct 22, 2010
I'm having some problems with errors reported by fsck on my EXT4 root partition on my Ubuntu 10.10 installation... If I run fsck I get the following output:
Code:
# fsck -n /dev/sda1
fsck from util-linux-ng 2.17.2
e2fsck 1.41.12 (17-May-2010)
Attenzione! /dev/sda1 montato.
[Code]....
View 4 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
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
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
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
Aug 16, 2010
I have setup the Red Hat system and installed MySQL through the Add / Remove Program. I have RHEL 5.4.
When MySQL is being started manually it is being started as root. However, when MySQL is being started using the services command it is started as the user MySQL and it doesn't work.
How can I start MySQL service as root? Or is there another way to fix that issue.
Let me know if you need more information (giving details on how to get it would be nice too).
View 13 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
Feb 8, 2010
I cannot see what the problem is here. I have installed MySQL 5.1.36 via YaST on my openSUSE 11.2 (32-bit) system.I can log in as root. I can "create user MY_user identified by 'my_passwd';" and a new user is created. But I cannot log in to the database using that new user name. I keep getting the message:
Code:
> mysql -b -u MY_user -p
Enter password:
[code]....
View 6 Replies
View Related
Jan 4, 2011
I am using Ubuntu 10.04.1 LTS x64. I would like to backup my /var/lib/mysql directory as a non-root user.
I have been backing this up using cron as the root user, but another admin in my company insists that we create a separate user to perform this task for security reasons. I have created a user, created a group, added the user to the group, but still cannot access /var/lib/mysql/mysql directory as that user. I would like that user to have +rx access only.
View 5 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 9, 2010
I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
View 3 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 3, 2010
Kmail 1.13.2 Problem on startup, error is from nepomuk, data storage. "cannot find Redland backend, nepomuk is disabled until fixed. Also see the following error from the akonadi console:
100503 10:00:15 [Note] Plugin 'ndbcluster' is disabled.
100503 10:00:15 InnoDB: Started; log sequence number 0 31413862
100503 10:00:15 [Warning] Can't open and lock time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without
[code]....
View 2 Replies
View Related
Jul 20, 2010
I Installed the maintained package, Day one everything worked fine, I set a dummy database and work on it from VM windows. Day two weird errors, I searched around couldn't find the problem, the error was related to The root user losing privileges. I don't remember the exact error. So I decided to Completely remove the DB with apt-get remove mysql-Server-5.1. It gets stuck during the uninstall, I left the machine for a day and a half to uninstall mysql. I realized it was no use, I tried to Restart and try again, but I am getting the same thing.
Code:
finito@finito-desktop:~$ sudo apt-get remove mysql-server-5.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
dbconfig-common libhtml-template-perl mysql-server-core-5.1 libaprutil1-ldap
apache2-mpm-prefork apache2-utils libmcrypt4 apache2.2-common libt1-5
libaprutil1-dbd-sqlite3 apache2.2-bin wwwconfig-common php5-common
javascript-common libjs-mootools
Use 'apt-get autoremove' to remove them.
The following packages will be removed:
mysql-server-5.1
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 15.7MB disk space will be freed.
Do you want to continue [Y/n]? y
(Reading database ... 231901 files and directories currently installed.)
Removing mysql-server-5.1 ...
it stays stuck at Removing mysql-server-5.1 ...
I can't progress I am at the brink now, my only option right now is format, but I don't wanna do that. This setup is almost 5 years old and I have gone with many ups and downs with it. From Windows to 8.04 to 8.10 to 9.04 to 9.10 to now 10.04 each year loving the resilience of Ubuntu and the Linux architecture. I don't want to believe that this has killed my spree.
View 9 Replies
View Related
