Got Locked Out Of Mysql. Won't Take My Password
Running MySQL5/PHP5/Apache2 on Windows XP Pro.
I setup my root password yesterday:
mysql>UPDATE mysql.user SET Password=PASSWORD("new password") WHERE User="root";
Query OK, 2 rows affected (0.12 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql>FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.24 sec)
Then, I was successfully able to logon to mysql as root.
Today, when I rebooted the computer and tried to logon:
mysql -h localhost -u root -p
I got the following:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I verified that mysqld-nt.exe was running as a process.
I suppose I could have done the steps incorrectly(as a newbie) but is there an easy way to proceed.
View Complete Forum Thread with Replies
Related Forum Messages:
It Wont Let Me Reset My Password For Mac Osx
if mysql is not letting me reset my password what can i do?. I'm using Mac Osx and my password only works sometimes. I dont understand it. Actually it only worked once. I want to reset it but it wont let me kill the mysql. I was running mysql or attempting to try to start mysql 4.0 and i just downloaded the 4.3.4 or something of mysql and now its giving me this when i attempt the sudo /usr/local/mysql/bin/mysqladmin -u root -p shutdown: [Denise-Womacs-Computer:~] denisewo% sudo /usr/local/mysql/bin/mysqladmin -u root -p shutdown Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
View Replies !
Password/Username Locked Me Out Of PhpMyAdmin
I'm using MySQL 5.X on a Mac. I was trying to create a password and username for a new database. I created the database, then clicked on Privileges. Next, I created a password and username. Not only can I not access the database, I can't even access phpMyAdmin now; I get this error message:
View Replies !
MySQL Wont Start
I've just installed MySQL on my computer yesterday and it was running good at the time. Today I boot my computer and It won't load the MySQL service. I've added the MySQL path to the environment variables but that didn't solve the problem. I've attached the .err file below. My system is: PHP 5, MySQL 4.1 Apache 2 I'm conencting to my network with a wireless card if that has anything to do with it. Probaly not since its a local service?
View Replies !
MySQL Wont Start Up
Last night I was attempting to activate MySQL for one of my domains using the Ensim control panel. It gave me an error while activating, and shortly after i noticed all MySQL activity on my server was no longer working. Using ensim to activate the MySQL service I get the following error: Quote: Result : start for service mysql failed. Action start for MySQL failed with error. Failed to start service: mysql. The following error occured: Logged in using ssh i get similar messages. When I try to login to my MySQL powered blog system I get the following error: Quote: Got an error: Bad ObjectDriver config: Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View Replies !
Mysql Server Wont Work
i am having mysql install with Plesk 7.5 for windows and yasterday the mysql server wont work everytime i click to start it stop in same sec how can i solve the problem and did that will make m elost my db ?
View Replies !
MySQL (PHPTriad Download) Window Wont Display.
Have downloaded the PHP Triad software from SourceForge.net as have had problems getting Apache working after installing from the Apache.org site. Apache works using this version but when selecting the MySQL - D from the start menu, the pop-up window doesn't display, but it flashes on then off. There is no uninstall option, and this isn't displayed in the windows remove programs setting either. How can I remove and reinstall, or get this working?
View Replies !
Mysql Installed And Running But Wont Start (XAMPP)
hey iv installed xampp as i want to begin learning php and need the php and mysql servers, it all seems to be running fine in the control panel of XAMPP it shows apache and mysql as running. The problem is when i go to start mysql to create an actual database,by going: C:xamppmysqlinmysql the DOS window pops up and disapears and the motherboard beeps. Is this not the correct way of starting mysql for editing? im using wondows xp serivce pack2 and XAMMP 1.5.5.
View Replies !
Locked MySQL Processes
What does "locked" mean for the state of a MySQL process? My server has been rediculously slow the past day. I've been under 5% CPU for the past month, and all of the sudden today, with no significant changes in software or traffic, I'm at a constant 50% CPU. And one thing I notice that there are a ton of MySQL processes running, the majority of them "locked."
View Replies !
Access > Odbc > Mysql | Locked Table?
i have a mysql db and an odbc connection setup to it under user root. i need the odbc connection so i can have connectivity in access 2000. select queries work fine. i can view the tables in access etc. however update queries won't work for me. i know last week it worked, and this evening after it not working i opened up another copy of the database and it worked on that one... but only once, i went back and it didn't work in that one either. and for the life of me i cannot figure out what would be different with the database now. the error i'm getting is just the generic: "can not update 3 records due to lock violations" however, what is locking odbc/access out of the mysql db? is it mysql? is it odbc? or is access locking the records? im sure it isn't mysql, and i think it is odbc but i don't know where. i downloded new drivers for odbc. i thought about updating the access jet engine but couldn't find updates... Code:
View Replies !
Mysql Password() & Unix Crypt Password...
I am creating a user administration system where system administrator can activate services for a user, like webspace, a mail account or a subdomain. I now want to create a function that creates mysql databases and grant the right privileges to a user. But the problem is that mysql wants to have the plaintext password for the user in the "grant ... identified by 'pwd'" field, or in a manual query to update the password in the mysql.user table with PASSWORD('pwd'). I have another database which holds the passwords for the users, these password are stored the moment a user signs up and are used to activate services, for example ssh access to the machine. The stored passwords are encrypted using crypt(). So for adding a ssh service to a user, I simply do echo "$user:$pwdhash" | chpasswd -e. I have chosen crypt because some programs (like proftpd) don't take md5 sums. The problems is that I don't have the plaintext password. So I cannot add a mysql db. So I need to create a user in mysql with a crypt password. I tried to just "grant all privileges ... identified by 'nothing'" and then afterwards update the mysql.user table and putt the crypt password in there but it doesn't work like that. Does anyone have any idea on how I could fix this, how can I create a user in mysql without having his plaintext password and only having a crypt hash of it. I thought about not only storing a crypt hash, but also an md5 hash and a mysql PASSWORD() hash.. but I think that's an ugly solution.
View Replies !
Win2003 Wont Allow
i have just downloaded the lastest mysql and the server wont allow the new version of mysql to install the service/ EDIT: i had an older version of mysql 4.0.3 or there abouts and uninstalled it so it was running nicely
View Replies !
Query Wont Work
PHP Code: if(mysql_query("UPDATE users SET referer_score=referer_score+1 WHERE userID='$frommysql_referer'")) { die(mysql_affected_rows()); im trying to figure out why refer_score isnt being iincremented as im expecting it to. i know that the value of $frommysql_referer is the right value that im expecting it to be. just it wont increment referer_score. and mysql_affected_rows() wont print anythnig to the screen
View Replies !
Service Wont Start
I've JUST installed MySql onto my machine and I press the "Execute" button and it 1) prepares configuration, 2) writes the configuration file but then the whole thing flops and it can't start the service. it displays the following message: 'The service could not be started. Error: 0'
View Replies !
View That Wont Return Existing Rows
i have a problem performing simple query over view. To make it short, so anyone can recognize whether it is something im missing, this is the problem: * i have created few levels of views (some of them are based on actual tables and others are based on other created views or some mixed) * lets say the name of the view i have problems with is "aView" * when i perform "select * from aView" i get to see the view is correctly populated * when i add condition to the query above in some cases it returns ok results but in others it returns 0 rows (which is wrong) select * from aView where a=1, works fine select * from aView where a=1 or b=2, works fine select * from aVew where a=1 and b=3, returns 0 rows --- which is wrong(of course not by itself but in my case there are rows with ok values) same goes with using only the condition on b column a.) why wouldnt it fetch rows that are cleary in the view?? b.) is there any limitation on how high structure can we build using views
View Replies !
Enctype=multipart/form-data Wont Pass File Name
when i add enctype="multipart/form-data" to the form i cant get the file name into the databass... but if i leave that part out of the form then the files dont upload into my upload folder. so its either one or the other. is there a way to upload the file to my uploads folder and pass the data (filename) to the databass at the same time? . . . <form action="insert.php" method="post" enctype="multipart/form-data"> .....
View Replies !
Locked Myself Out
I setup MYSQL about 3 monthes ago(one of the latest versions, but don't know the exact version) and have had no problems since. Today I was fooling around with getting PHPNuke setup, but I was having some problems. Anyway, I went in and started fooling around with PHPadmin and checked some box and now I can't log into MYSQL. I get an access denied error. I think the password is fine, it's the permissions that are screwed up. I followed the suggestions in this link: http://dev.mysql.com/doc/mysql/en/resetting-permissions.html but I'm hitting a wall. I shut down the service fine, but when I try to restart the service with C:mysqlinmysqld-nt --skip-grant-tables it comes back without any errors, but it never restarts the application. I cannot do anything more in the process because I can't get MYSQL to start. I can restart the service fine, but the command above will not start MLSQL with the special permissions.
View Replies !
Locked Processes
When I execute the show processlist command I see locked( in state locked ) processes and if I kill one all the other get locked and the db freezes. When I kill all of them the problem is solved. This problem has been re-occurring. Can anyone tell me what and how to prevent it. Its a multithreaded mysql 3.23.41 server on linux. The table types in the DB are MyISAM.
View Replies !
Subsys Locked
Shut down my Linux PC running MySqld and rebooted this morning and = cannot get mysqld up. In services when I click on mysqld I get the = message "Mysqld dead subsys locked" when i restart the server it says = mysql succesfully restarted, but it isnt. When I try to stop the server = it comes back with an error message "failed to shutdown". So I rebooted = and during shutdown- shutdown mysql.............failed and- mysql = killall...............failed. Anyone have any ideas as to how I can sort this? would a reinstall of = Mysql work? would I lose legacy data doing this?
View Replies !
All Processes Are Locked
I have a problem with my mysql server. After some time of stable working all allowed by max_user_connections mysql processes have locked state. But there is no working query making the locking! All queries are locked for infinity amount of time. "Service mysqld restart" does not help! So I have to "kill -9" mysql process
View Replies !
Database Locked
all of a sudden i can't edit any table from 1 database from any editor i guess it locked up or something got an idea how can i remove this lock or what else could be causing this problem?
View Replies !
Tables Locked
I used mysql-3.23. I run "large" large query and they don't crashed. When I run the same query on mysql 4.1 some tables are locked. SELECT actor.first_name, actor.last_name, A.dba, A.source, A.processor, A.partner, A.date_send, A.a_status, A.date_received A.notes,C.request, C.request2, C.request, C.month, C.submitted, D.status, D.processor, D.approve, D.month, D.contract, B.b, B.switch, B.var, B.download, B.follow_up FROM actor, A, C, D, B where actor.id = A.actor_id and C.a_id = A.id and D.a_id = A.id and B.a_id = A.id;
View Replies !
My Database Locked
I'm very new to mySQL. Right now I have a page that I have accessing mySQL and displaying a certain number of entries with the while function: <?php mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later."); mysql_select_db($dbname); $query = "SELECT * FROM `mos_content` ORDER BY `id` DESC LIMIT 0 , 5"; $result = mysql_query($query); while($newArray = mysql_fetch_array($result)){ $title = $newArray["$title"]; $introtext = $newArray["$introtext"]; $fulltext = $newArray["$fulltext"]; echo $title . "<br>" . $introtext; } ?> However, in the webpage, the first entry comes up, and the rest don't display. I know the code works because I get 5 <br> tags total (as the limit).
View Replies !
Locked Out Of My Own Server
im using lampp with mysql. Anyway I was trying to give the root user a password because at the time it had no pass and it was making meta wiki mad. 20 minites later after messing with the my.cnf and doing alot of mysql -u root -p somehow shape or form I locked myself out, and im not sure what the hell I did. I went here ( http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html ) and tryed what they said but it dident work. I was wondering if you could just overwrite the pid file yourself with some fresh one. Anyway if someone could help that would be grait, I have root perms so that wont be a problem.
View Replies !
User Root Locked Out.
I have mysql 4.0.16 database running on a windows machine, it was running fine. I didn't use it for a week and now when I try to go into it and delete some records it tells me access denied for root, I can't create users or modify anything. When I do a show grants it says all grants for user root.
View Replies !
Performance On Database Locked
We are having a tough time tracking down a problem with my MySQL database. The version is 3.23.58 running as the backend for Request Tracker (rt2) by Best Practical. Occasionally (once every 3-4 days) all running queries on the table will be "locked". We use MySQL for a number of different purposes, and I can normally nail the problem down to a specific slow query, but that is not the case here. I cannot find any running queries at all. All connections are either in "Sleep" or "Locked". Has anyone else ever seen this? Is there a way I can determine which query is locking the others? Based on the time field from "SHOW FULL PROCESSLIST" I can tell which query has been locked the longest, and attampts to kill it never succeed. I am hesitant to upgrade to the 4.0 series until I have exhausted all other possibilities. We have had difficulty in the past with migrating internal apps to 4.0, so I am not sure I want to dig upgrade for an app we aren't familiar with (rt2). For completeness, you should know all tables are MyISAM and when I view the processlist, I am logged in to MySQL as root.
View Replies !
All Activity On Database Locked
The version is 3.23.58 running as the backend for Request Tracker (rt2) by Best Practical. Occasionally (once every 3-4 days) all running queries on the table will be "locked". We use MySQL for a number of different purposes, and I can normally nail the problem down to a specific slow query, but that is not the case here. I cannot find any running queries at all. All connections are either in "Sleep" or "Locked". Has anyone else ever seen this? Is there a way I can determine which query is locking the others? Based on the time field from "SHOW FULL PROCESSLIST" I can tell which query has been locked the longest, and attampts to kill it never succeed. I am hesitant to upgrade to the 4.0 series until I have exhausted all other possibilities. We have had difficulty in the past with migrating internal apps to 4.0, so I am not sure I want to dig upgrade for an app we aren't familiar with (rt2).
View Replies !
Locked Out - Root User!
Code: mysql> UPDATE mysql.user SET Password=PASSWORD('foobar') WHERE User='root'; ERROR 1142 (42000): UPDATE command denied to user ''@'localhost' for table 'user' mysql> Code: # /usr/bin/mysqladmin -u root password 'foobar' /usr/bin/mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation' ran /usr/bin/mysql_secure_installation Code: Set root password? [Y/n] Y New password: Re-enter new password: ERROR 1142 (42000) at line 1: UPDATE command denied to user ''@'localhost' for table 'user' Password update failed! and some more info... Code: mysql> show grants; +--------------------------------------+ | Grants for @localhost | +--------------------------------------+ | GRANT USAGE ON *.* TO ''@'localhost' | +--------------------------------------+ 1 row in set (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.01 sec)
View Replies !
Process Getting Locked Occasionally
We are using MySQL 5.0.22 with PHP 5.1.4 on Apache 1.2.2. The OS is Red Hat EL 3.0 with cluster suit. The application is a call center management system. We are intermittantly getting the error 1203 (Too Many User Connection) while connecting to the database. If we restart the Apache then things become ok. Otherwise, the users are unable to connect to the database. While doing a show process at the time it happens we find that a number of processes are in locked state. But the MySQL server is running and we can connect it with phpMyADMIN. We are using MyISAM tables and we are using replication of the database as well. The max_user_connection is set at 200. The hardware is having 2GB RAM and is running only MySQL. As we are not knowledgable enough, may be we are missing some information that we should have posted. Kindly let us know and we shall post all the required information.
View Replies !
Tables Locked During Indexing
I have an application that I work on that access' customer information via a MySql database. Recently we have had performance issues so we have had an index created for us. When deploying the new index we have noticed an issue where our application will receive an 'Sql Syntax error or Access Violation'. Now initally we thought this was a code problem until by mistake i had neglected to run the Index on one paticular machine that is running our application and they worked perfect. During Mid Day i decided to run the Index query and All of a sudden we started recieving the error again. I am wondering if when running the index, does MySql lock the table so that no read/write can be performed? If this is the case is there a way in either MySql Administrator or another tool that i can see what the status of the index is? (ie.. Completed, Percent completed or whatever)
View Replies !
Corrupt Database :: Tables Getting Locked
We have been having issue with mysql database because the tables are getting locked once in a while. i run huge process which keep running lots of queries for hours. mysql> select count(*),date from IVbidask where date > 20090226 group by date order by date; ....
View Replies !
Query/connection State Getting Locked
I am using MySql server 4.1.10a. I am facing problem while firing big query Like join with multiple tables multiple conditions Whenever I fire this kind of query, all other requests from other connections got locked. I am using MyISAM storage engine for storage. And database size near about 1.5 GB. It's a linux on IBM server duel xeon processor 2GB ram.
View Replies !
Replication And SELECT Locking, Tables Not Locked
My entire team has been banging their heads against the wall on this for months. Here's the situation: We have two servers in a standard master-slave setup. There are 4 tables on the master that are replicated to the slaves There are INSERT and UPDATE commands going through on the master There are SELECT commands running on the slave. These are the only commands running on either box. The INSERTS are capable of inserting 20,000 rows per second. The UPDATES are also capable of updating 20,000 rows per second. The SELECTS can take even more data per second. The issue is, the UPDATE from replication and the SELECT from the client are deadlocking, but the tables don't lock! Code: .....
View Replies !
Random Query, How To Keep Sort Order Locked?
PHP Version 5.1.6 - mySQL 5.0.22 Let's pretend we have 100.000 rows in a table (all containing images with details), and I want to display 100 images at a single frontend page, but randomly retrieved and keeping the sort order once initiated to a user session. With the normal RAND function, you have a chance to stumble on the same images when you navigate to the next page with again 100 items on. But even worse, going back to page 1, will return totally different results, and will freak out the viewer How to get a (fake) random listing on a fairly large database, where every requested row is unique, and the sort order is being locked (until you press a randomize button ie, or start a new session) while keeping speed in mind (so trying to avoid reading out all rows up front).
View Replies !
Random Password Vs. User Created Password For Site Login
Are there any security issues or other concerns that make one preferable? The client is pushing for user created passwords. I'm mapping out the basic functionality and front-end for a MySQL/PHP back-end that will be completed by a third party. I'm a novice to MySQL but familiar with PHP and their interaction. Mainly looking for anything to support one method over the other.
View Replies !
"/" Signs Wont Show After INSERT
I am doing an insert of a file path example c:inetpubwwwroot est.gif but after the insert to the database it seems like mysql has deleted the so now it only looks like this c:inetpubwwwroottest.gif Why is it like this.. i have tested to change to varchar, text, mediumtext and tested the 4 and 5 versions om mysql server, i also have tested the 1.0.4 connector and 1.0.5 connector.
View Replies !
I Can Connect With Db Password Or Blank Password
I have a password setup for root (% and localhost) in Mysql 5.0.26, I can connect ok no problem. I can also connect with blank password! I know it is checking the password cuz it fails if it's wrong. I'm sure I have only one account as well (tried to delete, recreate, etc... no change) select * from user where user='root'; | localhost | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... | % | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... Is there an option to accept blank password!? I have this problem only for root user; Other accounts are fine.
View Replies !
MySQL PASSWORD()
I have a field in my db that I assign a password() function so that when it is sent in from a browser form, i do "select userID, name, password from users where userID=$userID and password=password($password)"... this is just an example, but wondering what mysql uses to encrypt it.would it be better off to just use php's mcrypt or crypt myself? would that be more secure?
View Replies !
Cannot Set MySQL Password On My Mac
I had an old version of MySql on my Mac. I recently installed the latest version of MySql. I tried to set a password in terminal using the steps shown below, but I get the error message shown below. I don't remember the password for my previous MySQL installation. Welcome to Darwin! localhost:~ helpprob% alias mysql=/usr/local/mysql/bin/mysql localhost:~ helpprob% mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I have also tried: mysqladmin -password <new password> and the same command without the dash before "password." I have also tried searching the MySQL manual and have tried various things that I thought it was recommending, to no avail. In some variations of what I have tried, I get the same error message except the end reads, "password: YES)
View Replies !
|
TRACKER
