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,
do
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 ar
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 userna
.frm', but I think that I've fixed 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.
> D
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 wi
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 behavior:
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
> >>
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
>
> 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 actu
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 wi
Minor points:
Why didn't you add -I/usr/include/mysql to compile options instead of
changing to ?
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 ran into the errors you
11 matches
Mail list logo
