Hi,
I am connecting to a mysql server on a remote machine, and opened up port
3306 for this purpose. But, I am concerned about sending a clear text
password, via the mysql_pconnect() call. My question is, what is the
procedure for connecting to a remote server with an encrypted password? Or,
Hi,
I am on the machine 192.168.0 230, and I am trying to connect to the server
on 192.168.0.10.
mysql -h 192.168.0.10 -u username -p
I get back
ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111)
OK, so I tried to connect to the local server
mysql -h 192.168.0.230 -u username
Ha ha, I changed the remote permissions for the user to 'any host' and now
it works. Doh!
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
this now.
What happens when you try the 'mysql' command? I get the response
can't connect to local MySQL server through socket
'/var/usr/mysql/mysql.sock'
And indeed there is no such file.
Do you have this file?
-Original Message-
From: Richard Fox [mailto:[EMAIL PROTECTED]]
Sent
The MySQL daemon does not run. I installed the binary RPM's from the RH cd,
MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
execute correctly. The I run safe_mysqld , and I get:
[root@thor rfox]# /usr/bin/safe_mysqld
[1] 2212
[root@thor rfox]# Starting mysqld daemon
But the default table type is already MyISAM
That is the normal behavior for ISAM type files.
Convert them to MYISAM.
Richard Fox wrote:
Hi,
I have a mysql table which has a run_id which together with user_id
forms
the
primary key for the table. run_id is not null and auto
Hi,
I have a MyISAM table which has a run_id which together with user_id forms
the
primary key for the table. run_id is not null and auto-increment. I delete
records from this table, and add new records. I want the run_id to keep
incrementing and not reuse values, but here is the actual
Can your INT id be overflowing, i.e. reaches the max value for int and
starting at 1 again?
Rich
- Original Message -
From: Steve Hay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
Hi,
Continuing my troubles with
Hi,
I have a mysql table which has a run_id which together with user_id forms
the
primary key for the table. run_id is not null and auto-increment. I delete
records from this table, and add new records. I want the run_id to keep
incrementing and not reuse values, but here is the actual
This question relates to both mysql in general and the mysql++ C++ API in
particular, thus the adressing to both lists.
I have a DateTime object (really a formatted string) say 2002-07-10
11:38:38. I want to subtract some variable number of hours (from 0 to 11)
from it. How do I accomplish this
Minor points:
Why didn't you add -I/usr/include/mysql to compile options instead of
changing mysql.h to mysql/mysql.h?
Try posting to [EMAIL PROTECTED] instead, it's low traffic but the
correct list for mysql++
I upgraded to GCC 3.0.4 for other reasons and built mysql++ with that, and
never
11 matches
Mail list logo