'root'@'%' identified by 'password';
> use mysql;
> update user set password=password('password') where user='root';
> flush privileges
>
> Regards,
> Rich
>
>
> > -Original Message-
> > From: Mohammed
assword';
use mysql;
update user set password=password('password') where user='root';
flush privileges
Regards,
Rich
> -----Original Message-
> From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 15, 2006 12:53 AM
> To: mysql@lists.mysq
- Adelaide)
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: RE: ~ How to install 3 instances of mysql~
Hi Logan,
Thanks for the links. But how am i suppose to allocate my physical
memory for the 3 mysql instances. Pls guide me on the innodb memory
settings. My total RAM memory is 1 GB.
Thanks in
] [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 15 April 2006 10:45 PM
> To: mysql@lists.mysql.com
> Subject: Re: ~ How to install 3 instances of mysql~
>
> On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
>
> > To: [EMAIL PROTECTED]
> > From: Mohammed Abdul Azeem <[
3 instances of mysql~
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
> To: [EMAIL PROTECTED]
> From: Mohammed Abdul Azeem <[EMAIL PROTECTED]>
> Subject: Re: ~ How to install 3 instances of mysql~
>
> Hello Keith,
>
> Thank you very much for your guidence.
>
>
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
> To: [EMAIL PROTECTED]
> From: Mohammed Abdul Azeem <[EMAIL PROTECTED]>
> Subject: Re: ~ How to install 3 instances of mysql~
>
> Hello Keith,
>
> Thank you very much for your guidence.
>
> This is my exi
/bin/sh
> #
> # stop the MySQL database server
>
> /usr/local/mysql-5.0.18/bin/mysqladmin shutdown \
> -uroot_user_name -proot_password \
> --socket=/usr/local/mysql-5.0.20-srv1/data/mysql.sock &
>
> HTH
>
> Keith
>
> In theory, theory and practice are the s
Create 3 my.cnf files with different ports and sockets:
[mysqld]
port = 3306
socket=/var/lib/mysql/mysql1.sock
.
Launch server with:
bin/safe_mysqld --defaults-file=/usr/local/mysql/bin/my1.cnf
client:
/usr/local/mysql/bin/mysql -S /var/lib/mysql/mysql1.sock
stop:
mysqladmin -S /var/li
ructions already posted at:
http://marc.theaimsgroup.com/?l=php-install&m=114138567814319&w=2
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
> To: mysql@lists.mysql.com
> From: Mohammed Abdul Azeem <[EMAIL PROTECTED]>
> Subject: ~ How to install 3 instances of mysql~
>
>
Hi,
I need to install 3 instances of mysqld server on a single machine. Can
anyone let me know how this can be acheived ?
It would be helpful if someone can send me some links and suggestions
regarding the same. Also pls lemme know what kind of a configuration
file i need to have in order to ache
10 matches
Mail list logo
