ADVICE ON GRANT PRIVILEGES

Hi, I resubmited again for anyone with solution to assist me. I had one question. I would like to set permission for remotely backup using mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup A(10.0.0.1) server. The command I run at B server are: mysqldump --opt -h10.0.0

ADVICE ON GRANT PRIVILEGES

Hi, I had one question. I would like to set permission for remotely backup using mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup A(10.0.0.1) server. The command I run at B server are: mysqldump --opt -h10.0.0.1 -uadmin -pXXX comers > comers.txt (p/s : I want to dump

Mysql Defected

Hi, I'm installing mysql from source tarball (*.tar.gz ) version 3.23.41. For your Infomation, I'm installing MySQL on a storage server and connect it through my web server using Scsi controller. My problem are when user took a very long time to trying to retrieve data from MySQL server, e

Re: uninstalling

Hi Sandeep, I assume you are installing your MySQL in Linux environment. So be cautious on case sensativity. Remember to type 'MySQL' and not 'mysql'. First, run command : [admin]# rpm -qa | grep MySQL MySQL-client-3.23.38-1 MySQL-3.23.38-1 This will show all the related packaged in your box.

Query using SSL very slow and hang

Hi, Maybe my question here is not directly related to this topic. However, I wish somebody out there will had enough information to help me solve this probelm. I am developing marketing portal using Java language, deploying with Apache 1.3.12 + Tomcat 3.2.2 + Mysql-3.23.40 as my database server r

Replication Problem

Dear all, I managed to set up 1-way master-slave replication using MySQL version 3.23.33. The replication process run fine. However I found out that the master-bin.001 sited on master server log file is growing every day. My question is, are there any command that I can put into my.cnf on master

Help! Installation MySQL-Max Failed

Hi, Recently, I had downloaded a copy of Standard binary RPMs for MySQL-Max-3.23.39-1.i386.rpm and I try to installed it on Linux Red Hat 6.2. The command for installation as below: rpm -ivh MySQL-Max-3.23.39-1.i386.rpm. Here is the error I get after the installation. Giving mysqld a couple of

How to make symbolic link under windows

Dear all, Did anyone now how to make symbolic link for mysql data directory under Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would like to transfer it to D:\ecom. My Mysql version is 3.23.32, installed using the '.exe' file. I would like to know if this is possible? If

URGENT! Hard Disk Space limition and Symbolic link

G OUT OF DATABASE SPACE. Thank you in advance. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 ----- Original Message - From: "David Patton" <[EMAIL PROTECTED]> To: "tpchan" <[EMAIL PROTECTED]> Sent: Friday, June

HELP! Hard Disk Space limition and Symbolic link

Dear all, I installed mysql version 3.22.32 on Red Hat 6.2 using the rpm package. Since mysql data directory is stay in /var/lib/, plus my database is growing bigger day by day, my problem now is that the '/var' partition running short of free hard disk space. What I'm trying to do is to transfe

Re: changing pasword

Martin, You should try the following. It's work for me. mysql> connect mysql; mysql> update user set password=PASSWORD('newpassword') where user='auser'; mysql>FLUSH PRIVILEGES; Regard, Emanduel Chan - Original Message - From: "Martin RODOT" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]