php7
Posted by: fender (---.red-83-33-131.dynamicip.rima-tde.net)
Date: April 29, 2020 03:20PM

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

Options: ReplyQuote
Re: php7
Posted by: Otomatic (Moderator)
Date: April 29, 2020 05:02PM

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

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.2 32 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30 - MariaDB 10.4.12
Wampserver 3.2.2 64 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30/8.0.20 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - 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
Password Problem
Posted by: fender (---.red-83-33-131.dynamicip.rima-tde.net)
Date: April 29, 2020 07:00PM

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?

Options: ReplyQuote
Re: Password Problem
Posted by: Otomatic (Moderator)
Date: April 29, 2020 07:21PM

Hi,

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

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

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.2 32 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30 - MariaDB 10.4.12
Wampserver 3.2.2 64 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30/8.0.20 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - 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: php7
Posted by: fender (---.red-83-33-131.dynamicip.rima-tde.net)
Date: April 29, 2020 07:45PM

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"winking smiley;


// 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);

Options: ReplyQuote
Re: php7
Posted by: fender (---.red-83-33-131.dynamicip.rima-tde.net)
Date: April 29, 2020 07:46PM

to without Viruscsanner!!!

Options: ReplyQuote
Re: php7
Posted by: Otomatic (Moderator)
Date: April 29, 2020 09:16PM

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.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.2 32 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30 - MariaDB 10.4.12
Wampserver 3.2.2 64 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30/8.0.20 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - 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: php7
Posted by: Otomatic (Moderator)
Date: April 30, 2020 10:30AM

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.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.2 32 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30 - MariaDB 10.4.12
Wampserver 3.2.2 64 bit - Apache 2.4.43 - PHP 7.4.6/7.3.18/..../5.6.40 - MySQL 5.7.30/8.0.20 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - 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: php7
Posted by: fender (---.red-83-33-131.dynamicip.rima-tde.net)
Date: April 30, 2020 12:45PM

Ok
I will try it
Thanks

Options: ReplyQuote


Sorry, only registered users may post in this forum.