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
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