In your my.cnf, put a "bind-address" directive:
bind-address=xxx.xxx.xxx.xxx
Christian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> > mysql> show grants for user3;
> > +---+
> > | Grants for [EMAIL PROTECTED]|
> > +---+
> > | GRANT USAGE ON *.* TO 'user3'@'%' |
> > +---+
> > 1 row in set (0.00 sec)
> >
> > what am
Ok, thanks.
-
Christian Caron
> -Original Message-
> From: Greg Fortune [mailto:[EMAIL PROTECTED]
> Sent: 7 mars, 2005 13:58
> To: mysql@lists.mysql.com
> Cc: Caron, Christian
> Subject: Re: what is select_limit (and what is it used for)?
>
>
> It only affec
Hi,
the default "select_limit" is set to 1000. What does this mean and how can
it affect a server?
Is there some information out there about this variable? I can't find
anything except a one line description on the MySQL site...
-
Christian Caron
--
MySQL General Mailing List
For list archives
>
> That's because there's nothing particularly remarkable about
> dumping BLOB
> values. Possibly you could have problems if they're really large.
>
> However, I take it from your message that you're trying to
> dump a table
> with BLOB columns and not having success? If so, it'd be a
> goo
Hi,
I have been looking around (manual, google, etc.) to find out if I can use
mysqldump with BLOB tables, but to no avail. Is it possible to do so, and if
yes, is there any flag I need to give to mysqldump?
Or can you point me to the manual page that describes that?
The page http://dev.mysql.c
>
> No it's not a bug. Look up the DBI documentation and change
> the mysql_sock=
> location in your code OR in /etc/my.cnf define the
> mysqld.sock file to be
> stored in /tmp.
>
>
Hmmm... It's not a bug but I have to adapt to it? There is something wrong
with mysql_config not returning the r
> When I start MySQL, it does create the socket in
> /usr/local/mysql/. When I
> (or PHP, or Perl) ask mysql_config about the socket, it returns
> "/tmp/mysql.sock"...
>
> nrn6# ls -l /usr/local/mysql/mysql.sock
> srwxrwxrwx 1 mysqlmysql 0 Oct 21 09:30
> /usr/local/mysql/mysql.sock
Hi,
I installed a fresh copie of MySQL 4.0.21 on Solaris 8 (Sparc). I did put
the following in the my.cnf file:
==
[mysqld]
User=mysql
Port=3306
Socket=/usr/local/mysql/mysql.sock
log
[client]
socket=/usr/local/mysql/mysql.sock
==
Yes, but when I create a user with any other grants, it generates
automatically this "grant usage on *.*":
mysql> use Liste_MP3;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> grant select
mysql> show grants for nouveau@localhost;
+---
+
| Grants for nouveau@localhost|
+---
+
| GRANT USAGE ON *.* TO 'nouveau'@
11 matches
Mail list logo