SQL Edit Connection properties for localhost on Windows

Post your questions and problem reports here

Moderator: kfury77

Forum rules
Please try to follow these guidelines. This will help to receive faster and more accurate response.
  • Check the Support section of the corresponding product first. Chances are you will find your answer there;
  • Do not create new topics for already reported problems. Add your comments to the existing topics instead;
  • Create separate topic for each problem request. Do NOT post a number of non-related problem reports in a single topic;
  • Give your topic a meaningful title. Titles such as "A question," "Bug report" and "Help!" provide others no clue what your message is about;
  • Include the version number of the software you are using;
  • This is not an official customer support helpdesk. If you need a prompt and official response, please contact our support team directly instead. It may take a while until you receive a reply in the forum;
Post Reply
HIIWEBUILDER
Posts: 4
Joined: Wed Nov 07, 2007 1:31 am

SQL Edit Connection properties for localhost on Windows

Post by HIIWEBUILDER »

I am running WeBuilder and also have XAMPP installed and need to connect to the development localhost.

I have established the MySQL dbase on my localhost and can view, edit w/ PhpMySqlAdmin just fine (with password).

Now need to connect via WeBuilder, under the SQL tab.

LABEL: <databasename>
TYPE: MySQL
HOST: ?????????????????????
PORT: 3306
USERNAME: <databasename>
PASSWORD: <password>
DATABASE: <databasename>

I downloaded drivers, from the site and installed for MySQL 4.0 (recommended) . 4.1 is also offered at install time. NOTE that XAMPP MySQL is 5.1.

What does the HOST name look like when running locally on Windows, with localhost an WeBuilder --> XAMPP?

The folder where the database is located is:
D:\XAMPP\mysql\data\<databasename>

My code has lots of PHP and MySQL calls, so assume I need the above connection from WeBuilder.

Any input on this will be greatly appreciated.
User avatar
Karlis
Site Admin
Posts: 3605
Joined: Mon Jul 15, 2002 5:24 pm
Location: Riga, Latvia, Europe
Contact:

Post by Karlis »

Host name is "localhost".
Karlis Blumentals
Blumentals Software
www.blumentals.net
User avatar
Karlis
Site Admin
Posts: 3605
Joined: Mon Jul 15, 2002 5:24 pm
Location: Riga, Latvia, Europe
Contact:

Post by Karlis »

Also the DB drivers have been updated, now the setup includes 5.0 version for mysql

In fact the file was updated a year ago but somehow we forgot to upload it and nobody asked/reported.
Karlis Blumentals
Blumentals Software
www.blumentals.net
HIIWEBUILDER
Posts: 4
Joined: Wed Nov 07, 2007 1:31 am

Got it working fine, -- very nice !

Post by HIIWEBUILDER »

The SQL databases show just fine now. Excellent software.
Post Reply