mysql problem
 

1-)how can i create a mysql user or users on my machine has acc on mysql.
2-)i tried mysql hostname user pass no luck
3-)how can i get the user list.

The easiest way to do it is to install the MySQL Control Center. Its a nice GUI that lets you do all the administrative tasks as well as create and edit databases.

If you want to get busy in a shell with MySQL you can add users by checking out the 'mysqladmin' command. I forget the exact syntax for adding a user.

solved the problem it is done with grant command if any one intrested

GRANT gives users privelages on databases. You asked how to add users. Does GRANT also add users?

yeah i found a book on pdf format that adds user with that command but i deleted mysql databse by mistake now i cant do anything mysql is fucked up anyway to fix it.

Reinstall mysql. Why would you delete the MySQL database?

i tought it is a demo database not that important which packeaged i need to reinstall just mysql or mysql server or are there others btw what was the command to force rpm to install package that is installed on the system.

you should be able to do:

rpm -Uvh mysql-server*

The command is --force but you probably don't want to do that unless you know exactly what you are doing.

i got another problem this time i get this error

mysqladmin -u root password "newpasword"

i get
acces denied for user root@localhost

sometimes this darkstar.localdomain can not connect mysql server no autorized somting like that and i can not connect it with mysql cc either