WampServer

I am newbie using WampServer and I am trying to install Joomla 3.6.4 on my localhost.

In section Database Configuration I get the error


"Could not connect to the database. Connector returned number: Could not connect to MySQL."


.. Any idea what's going on? All help very gratefully received.

Hello,

The database must exist before installation of Joomla and you must use VirtualHost.

To show not only the simplicity but also the ease of use of VirtualHost, I will install Joomla 3.6.4 locally, which I had never done before and using an existing database since many hosts Allow only one database.
In addition, this is similar to what you would do at a web host.

- Wampserver 3.0.6 32 bits
- Apache 2.4.23
- PHP 5.6.25
- MySQL 5.7.14
- MySQL Existing Database :
-- Name : mydatabase
-- Type : mysqli
-- Host : 127.0.0.1
-- User : root
-- Password : xxxxxxxxxxxxxx

Download Joomla 3.6.4 package

- 1 - Where will Joomla be installed?
The answer, with VirtualHost, is anywhere!
Well, not exactly :
- On a fixed hard disk
- No SDHD card or other
- No USB drive
- It's possible, but avoid network drives and NAS
- In a path without spaces or diacritical characters.

I will choose a partition never used for a VirtualHost, in this case, my partition F:
- Creating a folder of any name (Of course without spaces!)
F:\joomla\
In this folder f:\joomla\ unzip the file previously downloaded, to get a set of style:
f:\joomla\.github\
f:\joomla\administrator\
f:\joomla\bin\
f:\joomla\cache\
f:\joomla\cli\
f:\joomla\components\
etc.

Now that the folder exists and the necessary files are present, we can proceed to the creation of the related VirtualHost.

- 2 - Creating the VirtualHost
- Launch Wampserver
- Start localhost
- From localhost, launch Tools, Add a VirtualHost
On the Add a VirtualHost page:
- In the box 'Name of the Virtual Host' put the name you want to assign to the site Joomla, for example:
my-site-joomla.dev
- In the box 'Absolute complete path of the VirtualHost folder', of course, put the path of the created folder:
F:/joomla/

Then click the 'Start VirtualHost Creation' button.

Among other things, it says that the files have been modified, the virtual host my-site-joomla.dev has been created and to be taken into account, it is necessary to:
- Right Click Wampamanager icon -> Tools -> Restart DNS
Therefore: do it

- Back to Home
And here, surprise, in the column Your VirtualHost, there is the name of the VirtualHost that you have just created:
my-site-joomla.dev
Therefore, one does not hesitate, one clicks on this name.

- 3 - Configuring Joomla
In the form displayed, you must enter the correct information, therefore:
- Name of the site: my-site-joomla.dev
- Description: Not required. What you want.
- E-mail (Super User): a valid email address. I put wampserser@otomatic.net
- Username: Your username. I put otomatic (you will have to remember it)
- Password: The password associated with the identifier above
- Confirm password: the same as above
(The rest of the information remains by default)
Next Button

- Database type: Mysqli
- Server Name: 127.0.0.1 (Preferable to localhost)
- Username: root (This is the name of the user of the database)
- Password: xxxxxxxxxx
- Name database: mydatabase (name of the database that already exists)
- Prefix tables: joomla_ (to recognize them correctly)
(The rest of the information remains by default)
Next Button

We see that some PHP parameters are not on the recommended values. They are left as they are; It will show that Joomla PHP errors have been corrected with version 3.6.2.

Install button
After a "certain time" (about 40 seconds):
--- Congratulations! Joomla! is installed. ---
Validate button Delete installation directory

- Administration button
Login and password are required, then Log in
And then you set up your Joomla.

And if you want to go directly to the administration:
'http://my-site-joomla.dev/administrator/'
Then login and password.

It goes much faster to do than to write
Note: This was really the first time I installed Joomla.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 11/27/2016 05:00PM by Otomatic.

im newbie in wampserver & joomla.. how to cr8 username (root) n database name ?

Hi,

> how to cr8 username (root) n database name ?
I did not understand what you would like to do.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

i mean.. how to create new database for MySQLi



Edited 1 time(s). Last edit at 11/27/2016 11:12PM by dean93e.

i trying to create using VirtualHost.. after done with name of virtual host, local ip n path .. its show message

Forbidden

You don't have permission to access / on this server.
Apache/2.4.23 (Win64) PHP/5.6.25 Server at 127.10.8.20 Port 80

Please see the links in my signature, for MYSQL Manual and phpMySQL manual

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 11/28/2016 09:53AM by RiggsFolly.

Hi,

> after done with name of virtual host, local ip n path
You yourself have written that you are a "newbie", so before you want to access your local sites from the outside, start by making them work properly only locally.
To create a database, use PhpMyAdmin.

I think I have done a lot, until a functional procedure to install Joomla, while I will uninstall it and never use it.

This site is for people having issues getting WAMPServer running and not a general HOW DO I site for everything web related.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Dean,

Joomla 3.6 will create its own database as part of the Joomla install process. You dont have to do it yourself.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-