I didn't found hostname.pid file. SOS SOS --- "J.R. Bullington" <[EMAIL PROTECTED]> wrote: > The next step is to shutdown mysqld, delete the > mysql and temp tables from > your /data/ folder, and then re-run the > scripts/mysql_install_db. That will > reinstall the mysql/hosts.frm, which will basically > reset your root user and > password. However, it will also kill any users you > have created. > > To reset the root password without "harming" other > mysql users: > > Shell> kill cat /path/to/mysql/data/hostname.pid > Shell> ./bin/mysqld_safe --user=mysql > --skip-grant-tables & > Shell> mysqladmin -u root password 'newpassword' > Shell> mysqladmin shutdown > > Then restart the mysqld like normal. Hope this > helps! > > J.R. >
===== ---------DIGITAL SIGNATURE------------------- ///Mohsen Pahlevanzadeh//////// Network administrator & programmer My work phone is : +98216054096-7 My home phone is: +98213810146 My emails is [EMAIL PROTECTED] My website is: http://webnegar.net ---------------------------------------------------------------- __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]