WampServer

1)Where i can change to php7
2)Where i can change to get more Kbit import to the mysql

- 1 - wamp(64)/instructions_for_use.pdf
- 2 - wamp(64)/alias/phpmyadmin.conf

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

Thanks
Its ok
I instalt the 3.2 64bit Version hi got PHP7

Now is nearly every things workin.
Just one mor problem I got.

I put in the phpMyadmin a new user and a pasword in but not works said allways
"Connection failed: Access denied for user 'lilly'@'localhost' (using password: YES"
I dont know what the problem!!
Mayby the virusscanner?

Hi,

> I put in the phpMyadmin a new user and a pasword
How ?

Did you reload users in PhpMyAdmin or quit and restart PhpMyAdmin?

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

Yes I tried every things
I start the laptop again!!


This the export of the user lilly by phpMyAdmin:

GRANT ALL PRIVILEGES ON *.* TO 'lilly'@'%' IDENTIFIED BY PASSWORD '*6E5F0F05F71F797A05EF10BAAFB911F209B1A332' WITH GRANT OPTION;


This is the code of the index.php


$server = "localhost";
$user = "lilly";
$pass = "xxxx";
$datenbank = "web_counter";

$web= "xxxxxxx";
$seite="a_index";
$ip = $_SERVER['REMOTE_ADDR'];
$datum = date("d.m.Y - H:i \h";


// Create connection
$conn = mysqli_connect($server, $user, $pass, $datenbank);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO count2 (web, seite, ip, datum)
VALUES ('$web', '$seite', '$ip', '$datum')";

if (mysqli_query($conn, $sql)) {
# echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

to without Viruscsanner!!!

Hi,

A priori, PhpMyAdmin does not create users with 'default_authentication_plugin=mysql_native_password' as the MySQL console does with :

CREATE USER 'lilly'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'text password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;
GRANT ALL PRIVILEGES ON *.* TO 'lilly'@'localhost' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'lilly'@'localhost' WITH GRANT OPTION;

I'll take a closer look at it tomorrow.

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

Hi,


It appears that you have registered the user lilly improperly in PhpMyAdmin.

User created from MySQL console with root user :

CREATE USER 'lilly'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'clearpasswordlilly' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;
GRANT USAGE ON *.* TO 'lilly'@'localhost' WITH GRANT OPTION;

With this user 'lilly' and its associated password, you can connect to PhpMyAdmin and the MySQL Console without any problem.
We delete the lilly user with the MySQL console with root user:

DROP USER 'lilly'@'localhost';

User created from PhpMyAdmin with root user :
- User Accounts tab
- Add User account
-- User name : lilly
-- Host name Local : localhost
-- Password [Use text field] : clearpasswordlilly
-- Re-Type : clearpasswordlilly
-- Authentication plugin : Native MySQL authentification
- Global privileges : Data - Structure - Administration
- SSL REQUIRE NONE
Go

With this user 'lilly' and its associated password, you can connect to PhpMyAdmin and the MySQL Console without any problem.

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

Ok
I will try it
Thanks