mySQL in Solaris

The administrator installed mysql on
/import/misc2/mysql-3.22.22/ in Solaris 2.7, however as a user, I experienced the following problem:
> {prompt:3} mysql
> ERROR 1045: Access denied for user: 'glo@localhost' (Using password: NO)
Then I asked the administrator to run the following command in mysql:
mysql>GRANT ALL ON *.* TO glo@localhost IDENTIFIED BY "password"
WITH GRANT OPTION

However, I experienced the same error message as before. Then the administrator tried to killed the daemon and restart, Finally I ended up with this:
{prompt:4}mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock)
{prompt:5}/import/misc2/mysql-3.22.22/bin/safe_mysqld
Starting mysqld daemon with databases from /etc/mysql
mysqld daemon ended
---------
Please Help. Thanks.

Did the administrator shut it down with mysqladmin or did he kill the process?

If he killed the process then try deleting the /tmp/mysql.sock file if it exists.

Robman

You also need to make sure that you run the mysql command with a "-p" to prompt for a password. That's what the (Using password: NO) means.

{prompt}3: mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 123 to server version: 3.22.30-log

Type 'help' for help.

mysql>

I get the same error if I don't place the ./ in front of the command, so
mysql -u username -p gives me the error
./mysql -u username -p doesn't give me the error
not sure what's different about this program then any other as to why this happens.