Re: administrtor-user

[Visolve DB Team]

Hi,
On which platform?
It do good in Linux and Unix.

Thanks
ViSolve DB Team.
----- Original Message ----- 
From: "Renish" <[EMAIL PROTECTED]>
To: "Visolve DB Team" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Monday, October 23, 2006 10:05 AM
Subject: Re: administrtor-user

I am using sql 4.1.21. useradd mysql itself is not working

Regards
 ----- Original Message ----- 
 From: Visolve DB Team
 To: Renish ; mysql@lists.mysql.com
 Sent: Monday, October 23, 2006 12:17 PM
 Subject: Re: administrtor-user


 Hi

 First,

    shell> useradd mysql
 Changing UserName and Group name for data directory
    shell> chown -R mysql:mysql data
  Create Initial database
     shell> scripts/mysql_install_db   --user=mysql
  Start the Server

 Then to User:

 First, use the mysql program to connect to the server as the MySQL root 
user:
     shell> mysql --user=root mysql

 1.  After connecting to the server as root, you can add new accounts. The 
following statements use
     GRANT to set up four new accounts:
     mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'  IDENTIFIED 
BY 'some_pass' WITH GRANT OPTION;
     [OR]
     mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'  IDENTIFIED BY 
'some_pass' WITH GRANT OPTION;

 2. mysql> INSERT INTO user (Host,User,Password) 
VALUES('localhost','UN','PWD');


 Then to Change Password:

 1. Passwords may be assigned from the command line by using the mysqladmin 
command:
     shell> mysqladmin -u user_name -h host_name password "newpwd"

 2. Another way to assign a password to an account is to issue a SET 
PASSWORD statement:
     mysql> SET PASSWORD FOR 'jeffrey'@'%' = PASSWORD('biscuit');

 3. mysql> SET PASSWORD = PASSWORD('biscuit');


 To Drop user:

 1. mysql> DELETE FROM user WHERE User='' and HOST=''


 Thanks
 ViSolve DB Team.
 ----- Original Message ----- 
 From: "Renish" <[EMAIL PROTECTED]>
 To: <mysql@lists.mysql.com>
 Sent: Monday, October 23, 2006 9:30 AM
 Subject: administrtor-user


 > Can u guys tell me..
 >
 > How can I be the administrator for the mysql and thenI I need to create
 > users x, y,z and assign them a password.
 > and give them privilages..
 >
 >
 > -- 
 > MySQL General Mailing List
 > For list archives: http://lists.mysql.com/mysql
 > To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]
 > 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]