Reset lost password on Server Logistics Mac OS X install
I'm attempting to follow instructions at the MySQL AB site: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html ...in order to reset a lost root password. I am using the Complete MySQL package from Server Logistics (www.serverlogistics.com) for Mac OS X Panther. I've read the installation manual from Server Logistics; I've read the instructions at MySQL AB; but each comes up with mysql: command not found, mysqld_safe: command not found, etc. Where can I find these tools in a default install of the Server Logistics Complete MySQL? Has anyone using the same configuration and OS done a successful reset of a root password and is willing to share their steps? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lost Password
Hello Listers, I have a problem in that I cannot find my user id and password to log into mysql as administrator. I can never remember passwords so I write them all down in a small book however when I reinstalled mysql early last month, evidently I neglected to write down the new user id and password in my book. I haven't touched telnet since then. So now I can't log in to create a new user or do anything else. sigh Is it possible to sit down in front of the server logged in as root and find the file that has this information and have a look at it? Maybe if I can see the user names it'll jog my memory as to the password. I can try a couple to see if any work. If this is not possible, what recourse do I have? I don't want to mess with the database and start over and I seriously don't want to have to do anything to mysql as it took me two weeks to get it to work with the DBI perl module. Now that it's working, I'm terrified to touch it in case it breaks. Thanks for any guidance. I promise this time to not forget to write it down. Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045
Re: Lost Password
you can always reset the mysql root passwd http://www.mysql.com/doc/en/Resetting_permissions.html Saqib Ali - http://validate.sf.net --- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, Carol Andrejak wrote: Hello Listers, I have a problem in that I cannot find my user id and password to log into mysql as administrator. I can never remember passwords so I write them all down in a small book however when I reinstalled mysql early last month, evidently I neglected to write down the new user id and password in my book. I haven't touched telnet since then. So now I can't log in to create a new user or do anything else. sigh Is it possible to sit down in front of the server logged in as root and find the file that has this information and have a look at it? Maybe if I can see the user names it'll jog my memory as to the password. I can try a couple to see if any work. If this is not possible, what recourse do I have? I don't want to mess with the database and start over and I seriously don't want to have to do anything to mysql as it took me two weeks to get it to work with the DBI perl module. Now that it's working, I'm terrified to touch it in case it breaks. Thanks for any guidance. I promise this time to not forget to write it down. Carol Andrejak Webmaster Delaware State University Grossley Hall Rm. 1 302-857-7045 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
server shutdown ? lost password ? (didn't set one)
apparently I can connect to mySQL, as a under privilege user, but can't created a new database, after two days, of getting this far, Now what? So, I did the [MacG4a:~] rnagle% mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [MacG4a:~] rnagle% Which is suppose to be the ALL Mighty COMMAND to get in, I even try to shutdown the server, (NO kill - 9 here !) can't according the online manual, Take down the mysqld server by sending a kill (not kill -9) to the mysqld server. The pid is stored in a `.pid' file, which is normally in the MySQL database directory: shell kill `cat /mysql-data-directory/hostname.pid` did that, with [MacG4a:~] rnagle% shell kill `cat /usr/local/mysql-3.23.53/data/MacG4a.local.pid' Unmatched `. [MacG4a:~] rnagle% shell kill `cat /usr/local/mysql-3.23.53/data/MacG4a.local..pid' Unmatched `. [MacG4a:~] rnagle% [MacG4a:~] rnagle% shell kill `cat /mysql-data-directory/MacG4a.local.pid' Unmatched `. [MacG4a:~] rnagle% [MacG4a:~] rnagle% mysqladmin shutdown mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)' [MacG4a:~] rnagle% [MacG4a:local/mysql/data] rnagle% pwd /usr/local/mysql-3.23.53/data [MacG4a:local/mysql/data] rnagle% ls -al total 16 drwxr-x--- 6 mysql wheel 204 Dec 29 18:34 . drwxr-xr-x 22 503wheel 748 Nov 18 16:00 .. -rw-r--r-- 1 mysql wheel 1700 Dec 29 18:34 MacG4a.local..err -rw-rw 1 mysql wheel 3 Dec 29 18:34 MacG4a.local..pid drwxr-x--- 20 mysql wheel 680 Nov 18 15:59 mysql drwxr-x--- 2 mysql wheel68 Nov 18 15:59 test [MacG4a:local/mysql/data] rnagle% -- Somewhere over the rainbow, the has to be a way to get access. Anyone, ( was going to do a restart, with options:Restart mysqld with the --skip-grant-tables option. can't even get there. Any Help would be appreciated, THANKS-! Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php