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
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
> 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
> 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
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
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
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:
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
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'
