Hi all,

I don't have the phpadmin and cpanel access now. Is there any way that I can create a new database or empty an existing database?

Thanks.

Originally posted by ebird
Hi all,

I don't have the phpadmin and cpanel access now. Is there any way that I can create a new database or empty an existing database?

Thanks.

Do you have telnet/ssh access?

Choon

Log in with telnet/SSH and execute these commands:

# mysqladmin -u root -p create dbname
[Enter root password or your mysql password]

# mysql -u root -p mysql
[Enter root password or your mysql password]

Run this command:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON dbname.* TO user@localhost IDENTIFIED BY 'passwd';

exit

If you are not using phpMyAdmin.You should visit www.mysql.com cos its not only about making database. There are lots of things other. Which you have to do from command prompt

:D

mysql front is a great program i love it

http://www.mysqlfront.de