> Do you know what is differnet between command
> mysql_connect and
> mysql_pconnect
>
> Thankx
>
This is a PHP question. This should've been the first
place you looked:
http://us2.php.net/manual/en/index.php
mysql_connect
http://us2.php.net/manual/en/function.mysql-connect.php
mysql_pconnec
Scott,
This may not be your exact solution, but if your
network address is 24 bit then you could just check
against the last octet, i.e. x >= 10 and x =< 100.
James
--- Scott Haneda <[EMAIL PROTECTED]> wrote:
> Given a IP range such as:
> 12.8.197.10 -> 12.8.197.100
>
> I want to store those 2
Lee,
On the MySQL side:
GRANT SELECT ON db.* TO user@'host' IDENTIFIED BY
PASSWORD 'password';
This will give 'user' from 'host' SELECT privileges to
all tables on 'db' (db.*).
http://dev.mysql.com/doc/mysql/en/GRANT.html
HTH,
James
--- Lee Zelyck <[EMAIL PROTECTED]> wrote:
> Hi All,
>I'
Brandon,
You'll have to create a user for the PHP script.
example:
In the above code you'll have to create a user for the
PHP script (mysql_user and msyql_password) and make
sure that it has the proper permissions. At minimum I
would think SELECT, INSERT, UPDATE and DELETE, for
that user with
What are the MySQL permissions for the phpmyadmin
user?
If you believe that you set the phpmyadmin user up
correctly in MySQL, Did you try a 'flush privileges'
in MySQL?
HTH,
James
--- ÀîÈñ <[EMAIL PROTECTED]> wrote:
> Hi
> I have installed mysql some software on aix5.2 .
> the edition is M
You could export the file as xml with either '--xml'
or '-X':
mysql --xml -u username -p db_name > dbfile.xml
http://dev.mysql.com/doc/mysql/en/mysql.html
HTH,
James
> - Original Message -
> From: "Scott Hamm" <[EMAIL PROTECTED]>
> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
> Sent:
Hello,
I am installing a LAMP setup. I've installed MySQL on
AIX, but that was binary (recommended for AIX by MySQL
site) and all I did was gunzip in the directory I
wanted MySQL installed in and soft linked the that
with '/usr/local/mysql'. I've just installed Apache2
and I am not sure if the or
What does your '/etc/hosts' file contain? Sounds like
it may have the following entry:
127.0.0.1 localhost.localdomain
change it to:
127.0.01localhost
or
Yes, add 'localhost.localdomain' to mysql.user
another option, Why not just SSH to 'daisy' and issue:
shell> mysql -u root -p
a
> i'm getting really confused with how to properly
> allow users to access mysql from other machines.
>
> that is, i tried this as mysql root user:
>
> GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.*
> TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
>
> after this, i can access mysql as 'dbus
