Port 3306 restricted to IP addresses

For the inbound connection on port 3306 of MySQL Server, how do I restrict the connection to some IP addresses something like 1.2.3.* What do I need to do in my.cnf file? Thanks in advance. NOBBY - Before posting, please che

Why queries only the first SELECT statement

Hi list, I am trying to making online telephone directory search. I have an input form which has input for name and SELECT option for the area. Name of this form file is 'searchtel.php' This form parsing is done by 'searchtelparse.php' file which has query, i.e $query with 'IF' statement for diff

Re: adding a user to a database

You should specify the machine address after @ something like 'localhost' or specify particular IP / name. I might do this. grant all on db.bsd to shadowgrl@localhost identified by "testing123" with grant option; When you connect remotely, you need to specify host name. NOBBY - Original Me

Re: ....from ms access to mysql

Someone in the list posted the following links. I went with the second one and it worked. NOBBY > http://www.convert-in.com/acc2sqlp.htm > http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp > http://www.winmysql.com/ > - Original Message - From: Fabio Amura <[EMAI

Re: SELECT query with TRIM and LIKE

Thanks Nathan, I think I will go with "SELECT * FROM table_name WHERE Name LIKE > '%$name%'"; NOBBY - Original Message - From: Nathan Bank <[EMAIL PROTECTED]> To: Tshering Norbu <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 12:25 PM Subject:

SELECT query with TRIM and LIKE

Dear list, I have a telephone database which has "Name" as one of the fields/columns. This field contains single name e.g Robert, double names e.g Robert Downing and more than double names. I want to make a SELECT query using a form whose input name is "Name" i.e '$Name' against the "Name" fie

Re: SELECT query with TRIM and LIKE

Thanks Nathan, I think I will go with "SELECT * FROM table_name WHERE Name LIKE > '%$name%'"; NOBBY - Original Message - From: Nathan Bank <[EMAIL PROTECTED]> To: Tshering Norbu <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 12:25 PM Subject:

SELECT query with TRIM and LIKE

Dear list, I have a telephone database which has "Name" as one of the fields/columns. This field contains single name e.g Robert, double names e.g Robert Downing and more than double names. I want to make a SELECT query using a form whose input name is "Name" i.e '$Name' against the "Name" fie

Re: Suppress WARNING

Tshering NORBU Webmaster DrukNet & Bhutan Telecom PO Box 134 Thimphu, BHUTAN Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Phone: Work: +975-2-326997 Home: Only on request - Original Message - From: <[EMAIL PROTECTED]> To: Tshering Norbu <[EM

Re: Cannot Access mysql database

Do you have a "root" user? I had similar problem and set new password: $shell> /usr/local/mysql/bin/mysqladmin -u root -h localhost -p password 'newpassword' Then I could get access to all databases using: $shell> /usr/local/mysql/bin/mysql -u root -h localhost -p'newpassword' Of course,

Implementing NEXT n BACK page in query

Dear list, I would like to query on the first page only the last 50 records/rows (order by ID desc) in the following script file which uses MySQL, and I want to have NEXT page for the 50 rows earlier than last 50 queried and continue similarly. I think I can use JavaScript for BACK page to go back

Re: Win32 installation problem...

Here is a link that I used to install MySQL on my machine running Win98 http://www.net-language.com/workshops/Default.asp?workshop=21 NOBBY - Original Message - From: "Jason Rackley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 21, 2001 6:13 PM Subject: Win32 installat