Interface to work with mySQL
 

Hi,
I have set up mySQL on Redhat. What is the interface to work with mySQL?

the terminal or phpMyAdmin

Thanks. How to call the interface, within terminal?

or if you've defined a username or changed the root password:
which will log you in as username and prompt you for the users password.

Sorry, I've got these
[huamin@CentOS65x64 ~]$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[huamin@CentOS65x64 ~]$ su -
Password:
[root@CentOS65x64 ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@CentOS65x64 ~]#

1) Ensure your MySQL server is actually running and try again.
2) If you are positive that MySQL is running then try to force a TCP/IP connection.

Thanks a lot.
BTW, how to resolve this?

mysql> create table t
-> (fld1 char(20))
-> ;
ERROR 1046 (3D000): No database selected
mysql>

Try creating a database first.