Re: Install MySQL on Windows XP

Hi there Yuan, Hopefully this article can be of some help to you: http://schalkneethling.alliedbridge.com/php/php-mysql-apache-set-up-how-to/ Regards, Schalk yuan edit wrote: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server

Re: Granting users localhost access

Hi there Pam, This should do the trick: update mysql.user set host = 'locahost' where user = 'username' Regards, Schalk Pam Astor wrote: How do I grant users, who already have a password, localhost access? I don’t want to change their passwords at this time.

Re: Granting users localhost access

Hi Pam, If you want to grant a specific user remote access i.e. from a shell or from an application that resides on a different machine then you will have to adjust the query I sent earlier: update mysql.user set host = '%' where user = 'AUserName'; FLUSH PRIVILEGES; The above two queries

Tips for migration

HI All, Can anyone give me some pointers, help, point me to articles with regards to transfering a MSSQL database to MySQL? Thanks! Schalk Neethling -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Creating Password Username with phpMyAdmin

are set. HTH Schalk Neethling AlliedBridge (code.google.com/p/alliedbridge) David Blomstrom wrote: Sorry for the beginner's question, but I'm confused. I can easily create passwords and usernames for my online databases by going into my C-Panel and clicking a MySQL icon. It fetches a page

1064 error

GP + Limpopo Classic + SA Model Portfolio + Top Model Challenge + Gauteng Model Classic + Year of the Model AS total_points FROM modelcup.ab_leader_board All of the rows does exist in the table and all row names are correct. TYIA! -- Kind Regards Schalk Neethling Web

Re: SCO issue

to agree that looking at Pg would be a good idea. Hopefully MySQL AB will make all this clear one way or the other ... Rich Allen Dare Do -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers

Creating virtual rows question

' AND cup = 'kids' AND current_pos 0 ORDER BY total_points ASC -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global

Re: Creating virtual rows question

Jacques Thank you, I will give it a try. Jacques Marneweck wrote: Schalk Neethling wrote: Greetings Please have a look at the following code and let me know if this is the correct way to create a virtual row. Also, after having run this MySQL returns the error that the row total_points

Re: Creating virtual rows question

-- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN

Not sure about Error

= ichppccode.ichppccode WHERE allergies.description LIKE '%CARBACHOL%' MySQL returns the following error: Not unique table/alias: 'demographic' What exactly is meant by this statement :( Thank you in advance! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4

Re: Not sure about Error

Dan Yes, I completely overlooked that. Thanks! Dan Nelson wrote: In the last episode (Jun 23), Schalk Neethling said: I run the following query against MySQL: SELECT demographic_no, first_name, last_name, chart_no, sex, year_of_birth, month_of_birth, date_of_birth, family_doctor

Re: Restoring mySQL dump

: http://lists.mysql.com/[EMAIL PROTECTED] -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel

order by confusion

.? Any help would be appreciated. Thank you! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com

Re: joining six tables by mutual column

Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Schalk Neethling [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 00:52 To: mysql@lists.mysql.com Subject: joining six tables by mutual column Greetings

joining six tables by mutual column

. Any help or pointers will be appreciated. Thank you. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global

Windows Installer

whether there is a known bug. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support

Re: MySQL Database Designer

X. Do you have a good suggestion? Regards, Andreas -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We

Problem connecting to MySQL server

: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Any ideas why this is happening? Any help on pointers to where I may find more answers will be appreciated. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers

Upgrade - Downgrade problems

install of MySQL 4.0.22. I would appreciate any help or pointers. I am on WindowsXP as the development machine. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax

phpMyAdmin and MySQL 4.1

using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding

RE: LIKE question

If I search a field for 'doone' and one of the fields contains 'Lorna Doone' what is the best comparator to use as LIKE is skipping this one and I imagine '=' will do the same? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding

RE: Cannot be null problem

When sending form data via a form I get the following SQL error ERROR:-- SQLException - Message: The url cannot be null SQLState: 08001 ErrorCode :0 What does this mean? The row url, is not set to be not null. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President

RE: Query problem

and no other documents. Thanks for any help on this. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za

RE: MySQL book

Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois http://www.informit.com/safari/author_bio.asp?ISBN=0735709211 - New Riders Publishing -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4

FULLTEXT search

When doing a MATCH() AGAINST() search. Does a result get returned only when all of the words in the AGAINST() 'tag' matches a document or if any words match. Basically is this an AND or OR type of result that is returned? Thanks! -- Kind Regards Schalk Neethling Web