Beginner having basic problems
Posted by: diz79 (---.as13285.net)
Date: September 26, 2017 07:33PM

IM using windows10 64bit, WampServer 3.1.0 64bit
3 - Apache Version
4 - PHP Version
5 - MySQL Version
WampServer icon green



7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines with the name [localhost] in them?
* Active means no # at the beginning of the line.


If the WampServer icon is green:

8 - Do you have access to localhost (Homepage WampServer)? not found
8a - If so, is there an error message at the bottom of the page? The requested URL /anti/wp-admin/ was not found on this server.

9 - Do you have access to phpMyAdmin? no

10 - If you refer to an error message, please include the EXACT wording of the error in your post see below
11 - If you use an Antivirus and / or Firewall, please include the names of these, avira
12 - What is the full path to the installation of WampServer (eg D:\wamp\)
13 - If you have one or more Virtual Hosts defined, please show their definition(s)







Ive been using wampserver just this week and im having problems wirth phpmyadmin, when I first set it up it worked great I worked on my website and then when finsihed loged out and came basck the next day.

I then came accross the skype situation which I fixed no problem regarding the ports. But then when trying to login again it wont let me using root and empty password. Ive gone through several you tube videos and I couldnt find a solution with 1045 error etc and it didnt sort it. So I then cleared everything off the computer and reinstalled, did my website again last night worked great and today I have same problem gone through everything again and I cant login, wierd thing also on the login now it doesent show msql at bottom anymore


This is the error

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

Im using avira anti virus

I dont no answers to all questions but have tried best I can

If anyone can help would really appreciate it, I know its probably been asked loads of times.

Thanks in advance.



Edited 1 time(s). Last edit at 09/26/2017 07:44PM by diz79.

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: Otomatic (Moderator)
Date: September 27, 2017 03:54PM

Hi,

See pointq 21 and 21-a of TROUBLESHOOTING TIPS

> 7 - In the file c:\Windows\System32\drivers\etc\hosts
Actives line MUST be
127.0.0.1 localhost
::1 localhost

Can you go into MySQL console?
- Left-click wampmanager tray icon -> MySQL -> MySQL console
As there is no password after Wampserver installation, just hit Enter after the console ask for Password.

Do the same for MariaDB console.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (---.as13285.net)
Date: September 28, 2017 12:20AM

Thanks for reply

This is what mine says, it looks ok to me....


# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost

I can get into both consoles no problem, what else do I need to do?

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: Otomatic (Moderator)
Date: September 28, 2017 09:22AM

Hi,

Quote

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost

In the example I gave you, did I insert # at the beginning of each line?

The # character at the beginning of the line means that it is a comment, so the line is not active.
Put in the hosts file ONLY the two lines cited in my example, without # at the beginning.

If you can access consoles, this means that you are allowed to connect to MySQL or MariaDB.
Connecting to MySQL via PhpMyAdmin uses another process whose success may depend on the browser used or the anti-virus or firewall rules.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (---.as13285.net)
Date: September 28, 2017 09:29PM

Thanks again

In order to save it without # I need administrators permision which seems rediculous as on the wampserver icon it has the shield for this.

How can I possibly change this?

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: Otomatic (Moderator)
Date: September 28, 2017 09:59PM

Hi,

Modify then save hosts file with Notepad++ has no relation with Wampserver and administration rights.

In your case, I think the culprit is the Avira antivirus.

Launch Avira.
- Tools, Configuration (or F8)
- Generalities
- Security
- System Protect
-- Uncheck Protect hosts file from modifications
- OK

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (213.205.195.---)
Date: September 29, 2017 02:37PM

Im now getting this....

Unable to connect

Firefox can't establish a connection to the server at localhost.

The site could be temporarily unavailable or too busy. Try again in a few moments.
If you are unable to load any pages, check your computer's network connection.
If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web.

Iwas going to look at you tube tutorials but ddint want to mess with it anymore and stop our current progress. SHould I use chrome maybe instead or is it something else?

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (213.205.195.---)
Date: September 29, 2017 02:55PM

I re did in note ++ and it looks fine when I look at it in just notepad it looks like this would this effect anything?


127.0.0.1 localhost
::1 localhost

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (213.205.195.---)
Date: September 29, 2017 03:31PM

I can now get to php myadmin login but now having same peroblems with password. I go in change password to root and username to root and still doesent work, I ve also done username root and passowrd left empty still getting #1045

Really confusing

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: Otomatic (Moderator)
Date: September 29, 2017 04:10PM

Hi,

See file : wamp64/read_after_install-english.txt
The same information was given just at the end of the Wampserver installation.

> I re did in notepad ++ and it looks fine when I look at it in just notepad
> it looks like this would this effect anything?
Note 3 in TROUBLESHOOTING TIPS
(Note 3) - Text editor ======
*Important Prerequisites About the text editor being used: To edit the files, you must use a text editor, but not just any one. Some text editors, such as Notepad (notepad.exe) in Windows, are not able to correctly view files with Unix line breaks*, others recode surreptitiously the line of type Unix in type Windows/DOS, others still change the used character sets or add headers ; However, it is imperative that the end-of-line types or the character sets of the Wampserver files are not altered, otherwise it will generate impossibilities and errors when it is used. That's why I strongly recommend to use a free, powerful text editor like Notepad++ that you can find at Notepad++ (If you use a text editor like UtraEdit, it will not be a problem).
* The characters indicating the end of lines are of three types:
- Windows/DOS : CR - LF (Carriage Return - Line Feed) Two bytes 0x0D and 0x0A
- Unix : LF (Line Feed) One byte 0x0A
- Mac : CR (Carriage Return) One byte : 0x0D

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (---.as13285.net)
Date: October 01, 2017 01:40PM

I understand that I just cannot edit in notepad anyway as dont have permission, I only edited in notepad ++ I just wondered if it effected me getting in to php my admin.

Im still in same position as cannot get into to phpmyadmin due to

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

So no further forward

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: Otomatic (Moderator)
Date: October 01, 2017 03:59PM

Hi,

Try to disable xdebug.
Left-Clcik wampserver tray icon -> PHP -> PHP extensions -> Zend extensions -> php_xdebug 2.5.5
to uncheck it.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (---.as13285.net)
Date: October 03, 2017 07:24PM

Thanks but didnt work

it says this at top

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

and this at bottom

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

It only has username and password now

Im sure before it also said msql underneath not sure if this helps?

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: diz79 (213.205.195.---)
Date: October 05, 2017 02:41PM

Ive now reinstalled for the third time and it works fine, the problems start to happen when I turn off the computer and put back on, so every install once the computer is turned off and back on something must happen to the all system, does anyone no why this is?

Im obviously now getting the above posts message. Is there something im doing wrong prior to switching off the pc or is it just a usual error?

Any help would be greatly appreciated.

Options: ReplyQuote
Re: Beginner having basic problems
Posted by: Otomatic (Moderator)
Date: October 05, 2017 04:11PM

Hi,

> Im obviously now getting the above posts message.
> Is there something im doing wrong prior to switching off the pc or is it just a usual error?
See point 21-a of TROUBLESHOOTING TIPS

But I don't think that the problem is here as you can connect to Mysql or Mariadb console after retsart Windows.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.