Lost Password To Connect
I dont remember at all what was the password when installing Mysql 5
now when i try to connect with mysql administrator i cannot come in
i am using windows xp prp
where can i find my password ?
View Complete Forum Thread with Replies
Related Forum Messages:
Root Password Lost
I am an Oracle DBA and new to MySQL. I have to do some urgent work on MySQL but problem is that I have been assigned a user/password which does not have access to grants tables (mysql schema). My user has access to only one database, and is allowed to connect only from the same machine which hosts the database (which is on linux). So, I am not able to connect to database from my Windows machine having GUI database client tools. The actual DBA of the system who had root password has gone and now nobody knows the mysql's root user password. I wanted my user to be able to connect remotely which requires changes in grant tables, but only root user can grant this priviledge. Can someone please help me? how can i get the priviledges that only root can grant? is there a way to know root password or, to reset root's password? plz help.
View Replies !
Lost Phpmyadmin Password, Can't Do Backups!
I'm trying to run a backup on a bitrock install sugarcrm on linux. apache is running on port 8888, i try to get into phpmyadmin but it asks for user and password. I don't know what the user/password is. I saw user file so i know user = administrator. but I don't know password. I have access to the httpd.conf file. I see the last part of the file concerns authentication for phpmyadmin. Is there a way to turn off authentication? I just need to get a backup. I also try to use the command line but i get error 2202. it can't read the /tmp/mysql.sock file. i know mysql works because sugarcrm works fine from a browser.
View Replies !
Lost Password For MySQL Table....
I need the DBPASS for one of my MySQL databases. Unfortunatly I made it a while ago and never thought i would need to know the password. Im not sure what the password is.... Ive got two options: 1. find out the old password 2. reset the password to another password but the problem is then i need to tell the forum (invision power board) that the password has changed. If anyone knows how to change the DBPASS on invision power board,
View Replies !
Lost Password Black Hole
Is it possible to gain access to a MySql db without the password. Yeah i know sounds like i am hacking into something i shouldn't be. Rather it is the colmanation of some less than perfect management tequnics that have left passwords and usernames disapearing with former employees.
View Replies !
Lost 'mysql Root' Password
I logged in as root successfully and created a user with access to a certain database. I could not do all i expected to with my new user so I tried to login as root again and now I cannot login with my old password, new users password, etc. Only my own development box, so no great catastrophe however I do need to login as root. Can anyone give me a way to change my mysql root password? or point me to site that does?
View Replies !
Lost Username And Password To MySQL Server....
I have been using the MySQL control center and had my usernames and passwords for the MySQL server stored in the control center. I recently lost everything on my PC including the usernames and passwords. Does anyone know if there is a way to reset or remove the passwords from MySQL so that I can make new ones? I do have the root password for the server that MySQL is running on.
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 !
Cannot Connect With Root Password
I've set my root password (or at least I think I did!), but am unable to connect to localhost with it. Now when I try to connect using root and that password - i receive a 'command not found' error.I'm totally perplexed. This is a new installation and I 'thought' I followed the instructions - but apparently not. Can I remove this installation (and how would I do that?) and try to install again?
View Replies !
Cannot Connect To MySQL Using Password.
username: userx host: % password: 1111 (with full privilege) # mysql -uuserx -p after entering the password, I fail to connect to the server. I cannot connect to Mysql server with the client application either. If I delete the password, I CAN connect to it with both mysql and client application.
View Replies !
How Do I Connect To MySql Without Password
I have given a password to root user. But I want to connect to the databases in the MySql without password during development. How do I do that? I am asking this question because I am having the following problem when I tried to connect thru php : Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in C:Program FilesApache GroupApachehtdocs estmysql.php on line 5 connect error: Access denied for user 'root'@'localhost' (using password: NO) My php code: mysql_connect("localhost", "root") or die("connect error: ".mysql_error());
View Replies !
Warning: Mysql_connect() [function.mysql-connect]: Access Denied For User 'debscrof'@'localhost' (using Password: NO)
Have MySQL on a VPS running CPanel MySQL v4.1.22-standard Can access MySql fine through CPanel, phpMyAdmin etc all work fine, creating databases, deleting databases, adding users etc However, when I try to use MySql from a website, it fails I created a user "test1" (which then got the username "debscrof_test1" from CPanel), a password for the user "test2", and then added the user to a new database "testdb" with all priviliges Then a simple script to connect to the database (as I am trying to locate the source of the errors), as per below: <?php $dbhost = "localhost"; $dbuser = "debscrof_test1"; $dbpass = "test2"; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'debscrof_testdb'; mysql_select_db($dbname); ?> Have tried with " and ' around the values, with 127.0.0.1 as the host... still with the same error message: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'debscrof'@'localhost' (using password: NO) in /home/debscrof/public_html/testdb.php on line 6 Error connecting to mysql ...any suggestions why I cannot connect? (and why it says password: NO)!
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 !
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 !
Lost. <_>
I am currently learning PHP, and know a bit of it so far. Currently I am using a login system that checks for a file named what the person typed for the username, and then checks inside the file for the password. I really need to know how to use a MySQL database. Can someone explain this really slow to me? Every site goes through it really fast not explaining all the details. And could you help me figure out how to make a login system?
View Replies !
Lost Tables
I may have lost some tables in one of my databases. phpmyadmin shows me the DB name with a 6 in brackets next to it--indicating that there are 6 tables in the db. However it doesn't list them and says 'No tables found in database.' in the command line I can select the database but it indicates that all of the tables don't exist. Looking at the files on the server I can see all of the tables in the folder mysql/data/<database_name> as .frm files. There are no .MYD or .MYI files though. I found a a file called 'ibdata1' in the mysql root directory which looks to have all of my data in it.
View Replies !
Lost In A Select
I have a problem with a query : describe autors ; +---------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | tinytext | YES | | NULL | | | surname | tinytext | | | | | +---------+----------+------+-----+---------+----------------+ describe unione ; +-----------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | book | int(11) | | | 0 | | | autor | int(11) | | | 0 | | | coautor | int(11) | YES | | NULL | | | argument | int(11) | YES | | NULL | | | editors | int(11) | YES | | NULL | | +-----------+---------+------+-----+---------+----------------+ $query1="SELECT pubbl,code,title,subtitle,volume,name,surname,editor,argument,year,book_index FROM autors,books,editors,unione,arguments,user_index WHERE autors.id = unione.autor AND books.id = unione.book AND editors.id=unione.editor AND arguments.id=unione.argument AND user_index.book_index = book.id" I need to select name,surname from table autors ( to match "autor" in "unione") , and then again as name2,surname2 from the same table to match the record "coautor" in the table unione ... but seems i'm not able to put all togheter .
View Replies !
Lost Access
I run a control panel called CP+ on a VPS with CENTOS 3.8, mysql 5. Now, I accidentally replaced allowed hosts for root@localhost from LOCALHOST to ANY and now I CAN log in as root but I now have NO access at all via through the SSH Shell or through my control panel. I get the following error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Trying to list users in the mysql DB table users yields me this error. select * from user order by user failed : SELECT command denied to user ''@'localhost' for table 'user' Is there anyway to reset the root user to localhost???
View Replies !
Data Lost
I accidently deleted some of my data from my table in my java code using resultset.deleterow method and earlier i had a copy of the database, what i did was went to installation directory of mysql/data/mydb and copied the folder mydb which had some .frm files in, i have the folder in the pen drive, is there a way to get the data back as when i pasted the folder from the pen drive to mysql/data/ it didnt brought the data back.
View Replies !
Lost Databases
After restoring yesterday's backup (a simple file-copy backup), all my databases seem to have disappeared. The directories and files are still there. I need the database back.
View Replies !
Connection Lost
I've got the following problem: I've an select wich gets binary Data out of my sql-table. The type is longblob and i've lauded some files into it previously with the LOAD_FILE function. The files have a size between 0.5 and 3MB. I'm loading the data out of the tables with a select like: SELECT data FROM files WHERE file_id=1 After executing the command and some seconds waiting (70 seconds) i get the error "connection lost". The file i'm actually trying to load has a size of 1,5MB. (Im using mysql with C++ and the execQuery returns with false after that 70 seconds). The code above worked fine as long as i use my computer as client use the server in my LAN or the remote server (client and server located in Germany). When my mate tries to use this code from India the above error occures. The question now is how can i handle that error? What can i do to get the file even if the inet connection might be a little bit unstable or slow? Im specially interested in the way how the communication between client and server works. Is the "connection lost" because of instability or because of a timeout? Every other query works fine from india, only this one which needs some bandwidth is failing. Besides: i've set the following parameters both for server and client: mysql_opt_timeout = 5; mysql_opt_max_allowed_packet = 16*1024L*1024L; //16MB for the mysql_opt_timeout: is this a timeout which is only important for establishing the connection? or does it affects every query?
View Replies !
All Privileges Lost!!!
After a big mistake in PHPMyAdmin, I've lost all privileges. Now i can't connect my database, is solution existing to create again a user with privileges? If not how to save my database before a new install of MySQL?
View Replies !
Lost Database?
I have had to repair my copy of windows and I have lost my databases. However I do have the .frm and .opt files for each database still in the mysql5.0/data folder. Is there a way to restore my databases with just these files?
View Replies !
Lost Conectivity
I am running phpdev w/perl mod, apache, MySQL, and everything seemed fine. I have been trying the MySQL CC and now I am getting "cannot connect to localhost 10050" Where did he come from and how do I get rid of him.
View Replies !
MySQL 5 Lost All Privileges
After creating a new user and executing "mysqladmin flush-privileges" I have lost all my privileges, I cant connect as root or any other user. Any idea why ? What can I do to restore or recreate my privileges ?
View Replies !
InnoDB And Lost Connections
I have just recreated several (large) tables in the database as InnoDB and reloaded them using my client application... These tables used to be MyISAM. I haven't tried playing with any InnoDB parameters, right now everything is default. Some operations a noticeably slower, which can probably be fixed. Speed is not essential right now. But I did run into one strange problem with a batch INSERT SELECT that would take about an hour with MyISAM. With InnoDB, if everything would work right, I would expect the query to take longer to execute. In fact, it gets aborted in about 30 minutes with the error 2013 -- lost connection during query. Something obviously related happens if I run it through JDBC -- then I get an exception with a message "unexpected end of input stream" also in about 30 minutes after the statement is submitted. I cannot not ALTER the table in question back to MyISAM for the same reason -- lost connection before the statement gets executed. I'm running MySQL 4.0.16 on Red Hat Linux (don't remember the version, but it's a fairly recent production release) with 1G of RAM.
View Replies !
Lost Connection :: Red Hat Fedora
i have mysql server located in in machine that used Red Hat 8.0 and my mysql server version was 3.23.58. I am trying to connect using my machine..And currently i used Red Hat Fedora...But when i am trying to connect to mysql server i got this error message..... "ERROR 2013: Lost connection to MySQL server during query" And i am also trying to killall my mysqld and start the mysql server through mysql kernel.... /usr/libexec/mysql -Sg --user=root& After that, when i tried to reconnect it, it's hang up !.....nothing to be done and i need to start my machine back to run mysql.
View Replies !
Lost Connection :: 2 Servers Over LAN
Ok heres a quick background on the situation. I run a large mysql orinated website, and tried splitting the load between 2 servers together connected via lan. On server 2 im running debian 3.0 testing/unstable with MySQL 4.0.24. When i try to execute a php mysql search script from Server 1 I get this error: Warning: mysql_pconnect(): Lost connection to MySQL server during query .............. Connection Error I have searched googled, and found a possible solution, which turned out did not work. I simply added these 2 lines to my /etc/hosts.allow /etc/hosts.allow mysqld : ALL : ALLOW mysqld-max : ALL : ALLOW Also I edited /etc/mysql/my.cnf and added wait_timeout 16000
View Replies !
Retrieving Lost Data
I imported an older dump file which resulted in 2 months of data being lost (ore than a million row) in prod. The backup is again quite old to import from. Is there a way to retrieve the data before the dump was imported? We really need to get the data back somehow.
View Replies !
Lost Leading Zeros
I have a table and all the values in the field int cloumn have lost their leading zeros e.g. "001" becomes "1" I want to store numberical dates like "060608" (YYMMDD) What is the bext type of field to use for this? varchar?
View Replies !
Root Lost Privileges
My root user lost privileges to the main mysql database. I can only view two databases (information_schema & another custom one). I can't view any users due to having no SELECT privileges. How do I restore the privileges for root back to the defaults?
View Replies !
Primary Key Lost Autoincrement, How To Add It Again To The Pk?
i am using mysql (5.0.37-community) in my Ruby-on-Rails webapp. I have a table 'comments' with an id column which is the primary key and has auto_increment. But somehow the auto_increment property got removed so i receive duplicate key errors when inserting new rows. So now i tried to give the auto_increment property back to the primary key. But alter table comments modify/change column does not work: Error: multiple primary key defined A solution would be to drop the primary key column and add it again with the auto_increment property. Im sure this would work in an empty database, but i got other tables that reference the rows that are in the comments table. Is there a way to just add the auto_increment property to the primary key without dropping the column? The following doesnt work too (foreign key checks disabled via set foreign_key_checks=0): alter table comments drop primary key Error: Error on rename of '.db#sql-f0_c' to '.dbcomments' (errno: 150) SQLState: HY000 ErrorCode: 1025 The only safe but working solution i can think of atm is: dump the whole database, adjust the create table statements and import the dump again.
View Replies !
HTTPS :: Lost Connection
I'm atmysqlting to connect to a remote MySQL host on an https connection. I'm using the standard mysql_connect, and I seem to get a response, but the function returns an error stating "Lost connection to MySQL server during query."
View Replies !
Restore Lost Databases
I committed the cardnal sin of computing, I upgraded MySQL without properly backing up my information. The new version couldn't find any of my old databases so I couldn't make a proper sql dump. I do however have all the folders with the original files/information associated with them. I tried just putting the database folder into the upgraded version of MySQL's data folder, but that didn't work. (I use phpMyAdmin for controling MySQL) I can see that there is a database by the name that I'm looking for, but when I try to view it, I get this error message: #12 - Can't read dir of './projectmcompanydb/' (Errcode: 13) figure out a way to restore this database? I'm using MySQL vMySQL 4.1.8 standard on OSX 10.3.9.
View Replies !
Lost Connection Problem
I have problems with the connection to the MySql server. The problem only occure when running the application on the webserver, never on the local machine. A strange thing is that it not allways happen, just sometimes. I wounder if the problem depends on a closed connection but then it should appear all the time or ..... ? Code:
View Replies !
Where Can I Find A Lost Database?
My OS X computer just crashed and with it mysql. So my problem is: where can I find my old database? It has to be physically stored somewhere! I'm starting to worry that I have lost a loot of important data,
View Replies !
Lost Remote Connection
I had a remote connection to my mysql databases working fine for ages, but today I heard it stopped working. I can't understand what is wrong - I thought we tested it after I changed the username & password for the db & all was well. I changed everything back to the default (original) connection info & still no joy. Even a short test script with the original master pw / username doesn't work. This is the error message I get from the test script: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'xxxxxxxxx.com' (4) in /home/xxxxxxxxxxx/conntest.php on line 2 Could not connect: Can't connect to MySQL server on 'xxxxxxxxxx.com' (4) I am on a shared server & therefore restarting the server isn't an option. Does adding a new user to the db screw up an existing remote connection? How would I fix it? I tried adding the port number to the hostname but that didn't work either.
View Replies !
Win200 - Lost Root Privilege
------=_NextPart_000_0023_01C35B54.206CFD60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am working on a Windows 2000 server. The version 4.0.13 was installed at the end of June because we are looking at using MySQL. Me and the other guy are novice with MySQL. I read the different emails about access and granting and password and flushing privilege from other people who couldn't get access. To get to the point, I know that the guy has altered the privileges and lost the password he would have set for root. mysqld was started from DOS window using mysqld and the window was closed. When I go to Task Manager, I see the mysqld process running. When I use now mysqld, if I try to specify root, because of not knowing the root password, I can't get correct privilege to run the shutdown command. If I just type mysql, I am user ODBC@localhost and the only database I see is test. Since mysql database is not visible, I know that I cannot set privilege from this user. So my goal is to desinstall v4.0.13, and re-install v4.0.14. But my current issue is "how do I stop the mysqld process?" Even if stopping from Task Manager is not the best approach, do I have another option?
View Replies !
ERROR 2013: Lost Connection
I am getting this error "ERROR 2013: Lost connection to MySQL server during query" when i try to connect from one client, on all other clients i don't have any problems connecting to specific server. Also from this client i can connect to the other servers without any problem.
View Replies !
Lost Connection To MySQL Server
I am using PHP to invoke mysql_query to my database. In most cases everything works fine and the query executes perfectly. Sometimes, I will get a burst of errors and the query will fail with the following error: Lost connection to MySQL server during query (err_no 2013) Does anyone know what could cause this? Could this be a mysql configuration problem, or maybe some network problem?
View Replies !
Lost My Root User's Privileges
Playing with phpMyAdmin, with my root user for mysql selected, I accidently clicked the delete button. It first removed my root user's privileges and then tried deleting the root user. It successfully lost my privileges, and because of that it wasn't able to delete my root user (insufficient privileges, I'm guessing). Now my root user can't do anything but log in. Anyways, can someone please tell me how to restore my root prvilages? I no longer have the ability to create new users, or give any users any privileges.
View Replies !
Insert Into Select - Connection Lost
my problem - want to write a query - find new records in one table and insert in an ohter to generate new keys... See below the statement - but wenn I execute the select part it works fine - as soon as I add the insert into for the select i loose the connection to the mysql server (Error 2013)
View Replies !
Lost Mysql.socket File
My mysql.socket file was accidentally erased and I wondered how I can get it back. Is there a way to create another one? I'm under mac OSX (leopard) and I already tried to reinstall mysql but I still have no file in /var/mysql.
View Replies !
Auto-Increment-variable Gets Lost And ....
I want to set up a multi-master-replication. Therefore i set the variable "auto_increment_increment". (http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html) 1.) The "auto_increment_increment"-variable gets lost after every server-restart - how can i make this variable persistant? 2.) When i insert values into a table with an auto-increment-field with phpMyAdmin (php-web-frontend), the auto-increment counts up like it did allways: 1-2-3-4-....only when i add a line with "SET auto_increment_increment=10;" before the insert-command, the operation works as expected. But i have not the capabilities to rewrite all my applications and manually to add this extraline to get this new feature properly to work.
View Replies !
|
TRACKER
