> -----Original Message----- > From: David Blomstrom > Sent: Thursday, February 10, 2005 09:21 > To: mysql@lists.mysql.com > Subject: RE: Need a New Password & Username > > Wow, I don't remember dealing with all that code the > first time around. Can someone show me EXACTLY what I > would write if my database is named my_database, and I > want to add the username private_host and the password > superstar? And if I don't have mysqladmin, can I type > it into the SQL Query window on phpMyAdmin?
GRANT ALL ON my_database.* TO 'private_host' IDENTIFIED BY 'superstar'; You can add host restrictions to by adding @'hostname' after the username. It's all there in the manual. Anyway, I haven't used phpMyAdmin, but if you can just enter queries, which I assume you can, then this will work. > > Thanks. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
