LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Mandriva
User Name
Password
Mandriva This Forum is for the discussion of Mandriva (Mandrake) Linux.

Notices


Reply
  Search this Thread
Old 01-17-2008, 11:33 AM   #1
popatopalous
LQ Newbie
 
Registered: Oct 2007
Distribution: Mandriva 2008.1 PWP, openSuse 11.0, ALL AMD 64
Posts: 29

Rep: Reputation: 15
Question 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???
 
Old 01-17-2008, 11:58 AM   #2
{BBI}Nexus{BBI}
Senior Member
 
Registered: Jan 2005
Location: Nottingham, UK
Distribution: Mageia 6, KDE Neon
Posts: 4,313

Rep: Reputation: 212Reputation: 212Reputation: 212
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
 
Old 02-02-2008, 04:35 PM   #3
gw1500se
Member
 
Registered: Mar 2004
Distribution: Mandriva 2010.0
Posts: 223

Rep: Reputation: 30
Quote:
Originally Posted by popatopalous View Post
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
confused on php and Mysql install spedsta Linux - Software 3 11-05-2004 01:36 PM
Mysql module.. confused =/ xushi Slackware 7 08-07-2004 07:51 AM
BLFS-CVS -- Confused about instructions! Zero-0-Effect Linux From Scratch 2 04-06-2004 09:33 PM
Confused with mySQL leetcrew Linux - Software 11 03-12-2004 11:06 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Mandriva

All times are GMT -5. The time now is 07:49 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration