How to play the DB via telnet?

admin

Administrator
Staff member
Hello,

I am a newbie of PHP+MySQL and I have some questions as follow:

1) My hosting company has provided some brower-based interface to let me create user and DB as follows:

DB Name: myaccount_mydb
DB User Name: myaccount_ray

I have create the above DB and user and add the user myaccount_ray to DB myaccount_mydb.

Remarks: Since I am using a shared hosting account, all my user name and DB Name will add my Hosting Account Name ("myaccount") as the prefix.

Well if I want to play with this DB via telnet how? I have try to do the following but the result is strange.

CASE 1.1
========

bash$ mysql -p
Enter password:
ERROR 1045: Access denied for user: 'myaccount@localhost' (Using password: YES)

CASE 1.2
========
bash$ mysql myaccount_ray -p
Enter password:
ERROR 1045: Access denied for user: 'myaccount@localhost' (Using password: YES)

CASE 1.3
========
bash$ mysql
mysql>
mysql>show databases
+--------------------------+
| Database |
+--------------------------+
| mysql |
| test |
| myaccount_mydb |
+--------------------------+
3 rows in set (0.00 sec)

mysql>
mysql> use myaccont_mydb;
ERROR 1044: Access denied for user: '@localhost' to database 'myaccount_mydb'

I think the problem I have is that I cannot activate the mysql prompt with my user name and psswd. Pls advise how I can play with my DB via telnet?

2) I already have some my_sql database and I want to upload it to my host? How?

Thanks you for your attention.

Regards,
Raymond
 
Back
Top