LinuxQuestions.org - Confused about MYSQL instructions.

- Mandriva (https://www.linuxquestions.org/questions/mandriva-30/)

- - Confused about MYSQL instructions. (https://www.linuxquestions.org/questions/mandriva-30/confused-about-mysql-instructions-614301/)

Confused about MYSQL instructions.

I just did a urpme/urpmi of mysql. When the urpmi run finishes it gives among other things:

To connect to the Instance Manager you need to pass the correct command line
options like in the following examples:

* mysql -u root --password=my_password --port=2273 --protocol=TCP
* mysql -u root --password=my_password --socket=/var/lib/mysql/mysqlmanager.sock

Please note you also need to add a user in the /etc/mysqlmanager.passwd file and
make sure the file is owned by the user under which the Instance Manager service
is running under.

Do they mean:

Code:

$ mysql -u root --password

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 406

Server version: 5.0.45 Mandriva Linux - MySQL Standard Edition (GPL)



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



mysql> --port=2273 --protocol=TCP;

mysql> --socket=/var/lib/mysql/mysqlmanager.sock;

mysql> quit;

Bye

And what user do I need to add to '/etc/mysqlmanager.passwd' [currently empty] and how do I add that user???

Urpmi the app mysql-administrator, it makes administration of your mysql database a lot easier. You can use it to add users, view logs, check memory status, etc :)

Quote:

Originally Posted by popatopalous (Post 3026027)

And what user do I need to add to '/etc/mysqlmanager.passwd' [currently empty] and how do I add that user???

You need to use MySQL commands within MySQL, not command line options. Go to the MySQL web site and use the online manual (http://dev.mysql.com/doc/refman/5.1/en/index.html). If you have the MySQL engine running then you just need to enter 'mysql -u root -p'. It will prompt you for the root password if there is one. To add one you will need to run the following commands once you get the MySQL prompt:

use mysql;
update user set password=password('somepassword') where user='root';

However, Nexus is right, you really want to use some admin tool (I use webmin) for managing MySQL.