Posted by Colin McKinnon on 01/20/06 23:41

Adam Plocher wrote:

> Ike, I'm not sure if this helps but you can use mysqladmin to reset
> your root password (or someone elses password, for that matter).
>
> More info here (search for mysqladmin on this page):
> http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

.....or you can use the mysql client (where you type SQL DDL/DML comamnds at
a command prompt.

Both of these require shell access to a machine with the programs available
and which in turn has access to the mysql port on the DBMS so you might...

some_user@home:~ $ ssh webdev@phpbox.mydomain.com
Password:
Last login: Fri Jan 20 20:58:42 2006 from console
webdev@phpbox:~ $ mysql dbadmin@mysqlbox.mydomain.com
Password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: x.y.z

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET PASSWORD FOR 'webdev'@'phpbox'
-> = OLD_PASSWORD('newpwd');

(if your starting from a MS Windows box get a copy of PuTTy)

HTH

C.

• Next in forum: Re: Can you _POST variables in php without using a <FORM>
• Prev in forum: only two concurrent php scripts at a time
• Thread view: Re: remote creation of MySQL db

[Reply to this message]