mysql problem

nakkaya · 03-18-2003, 05:16 PM

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.

Crashed_Again · 03-18-2003, 05:26 PM

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.

nakkaya · 03-18-2003, 06:03 PM

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

Crashed_Again · 03-18-2003, 06:05 PM

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

nakkaya · 03-18-2003, 06:09 PM

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.

Crashed_Again · 03-18-2003, 06:11 PM

Reinstall mysql. Why would you delete the MySQL database?

nakkaya · 03-18-2003, 06:17 PM

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.

Crashed_Again · 03-18-2003, 06:32 PM

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.

nakkaya · 03-18-2003, 07:58 PM

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