LinuxQuestions.org

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

popatopalous 01-17-2008 11:33 AM

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???

{BBI}Nexus{BBI} 01-17-2008 11:58 AM

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 :)

gw1500se 02-02-2008 04:35 PM

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.


All times are GMT -5. The time now is 08:45 PM.