UNIX for Dummies Questions & Answers

Hello.
I am using ubuntu linux and I have instaled on it mySQL.

The problem is that it doesn't add link to it in the application menu.

Hod I use from the CLI, and second how to add it to the application menu.

You might want to read up on MySQL. It's a RDBMS that runs as a daemon in the background, and as such will never appear in the application menu. Instead you can administer it from the CLI using the mysqladmin and the mysql commands, or graphically using MySQL Workbench or phpMyAdmin.

first thanks.

I have downloaded the manual and it say to do the following:
shell> mysql -h host -u user -p
so I wrote:
mysql -h Alex -u alex -p
It first asked for password, I gave it, then I got:
ERROR 2005 (HY000): Unknown MySQL server host 'alex' (1)


When I installed it, it didn't asked for any name for the server.
So how can I set name and make to know server host alex?

Where ? On "alex" or localhost ?

tyler_durden

I installed on my computer (running ubuntu) and I run the command form there, so I guess it is localhost, but my user name (in ubuntu) is alex.
That is why I typed alex.

"User name" is not the same as "host name" !!

A user is a live person (usually) and a host is a dead object (usually).

Run this command at the dollar-prompt -

Code:

mysql

and check the error message to see the user name and host name spewed by MySQL.

For local installation, you can omit the host name and just issue this command -

Code:

mysql -u root -p

and type in the password when prompted.

Thereafter, issue this command at the "mysql> " prompt -

Code:

select * from mysql.user;

to view the host and user information in MySQL's data dictionary.

tyler_durden

thanks.