how to create a database using telnet

[Ruth]

hi
can someone please give me instructions or a good site on how to create a database using telnet, because my host doesnt support a control panel for that at the moment and i need it as soon as possible

thanks :)

[Dave#]

Open a telnet session:

mysqladmin -u mysqlusername -p create databesname

[Ruth]

i used that command in telnet it says..

error access denied for user '@localhost' to database 'forum'

and when i click 'NEXT' for step 3 i get
Attempting to connect...

Connect failed: unexpected error from the database.

Error number: 1044

Error description: Access denied for user: '@localhost' to database 'forum'

Please ensure that the database and server is correctly configured and try again.

Click to go to the vBulletin website
any idea?

thanks

[Snoozy]

talk to your isp and ask what your username should be, if you have full control over mysql it should look like this,

%> mysql -u root -p
that should log you into mysql
it will give you a little welcome message.
then do this

mysql>create database forum;

DON'T FORGET THE SEMI-COLON!!!!!!
that should create it, the biggest problem I found is that I couldn't find out my username, again, if you have "full" control it should be root.
if you forget the semi-colon,

mysql>create forum
=>

you will get that symbol, that is mysql telling you that it is waiting for you to finish your command. This comes in handy when writing long commands.

If you'd like more help with this, check out:
SitePoint.com

they have some great tutorials on php/mysql.