MySQL Forums
Forum List  »  Install & Repo

Re: Error Connecting to DataBase!: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Amanda J
Date: October 07, 2017 09:40PM

after more reading...

using "//myxps/" in the Chrome address bar opens the WAMP home page.

So yes, I am getting the same result with my laptop as with localhost and localhost/index.php.

I also tried to run one of the larger queries that triggered this local server process - not returning a result (yet :))

So thought it might be sensible to look at some of the indicators for the local server you initially asked for when the db was on the shared shared server.

mysql> show variables like '%buffer_pool%';
+-------------------------------------+----------------+
| Variable_name                       | Value          |
+-------------------------------------+----------------+
| innodb_buffer_pool_chunk_size       | 16777216       |
| innodb_buffer_pool_dump_at_shutdown | ON             |
| innodb_buffer_pool_dump_now         | OFF            |
| innodb_buffer_pool_dump_pct         | 25             |
| innodb_buffer_pool_filename         | ib_buffer_pool |
| innodb_buffer_pool_instances        | 1              |
| innodb_buffer_pool_load_abort       | OFF            |
| innodb_buffer_pool_load_at_startup  | ON             |
| innodb_buffer_pool_load_now         | OFF            |
| innodb_buffer_pool_size             | 16777216       |
+-------------------------------------+----------------+

mysql> select
-> concat(round(sum(table_rows)/1000000,2),'m') rows,
-> concat(round(sum(data_length)/(1024*1024*1024),2),'g') data,
-> concat(round(sum(index_length)/(1024*1024*1024),2),'g') idx,
-> concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'g') total_size,
-> round(sum(index_length)/sum(data_length),2) idxfrac
-> from information_schema.tables
-> where table_schema='possbil';
+-------+-------+-------+------------+---------+
| rows  | data  | idx   | total_size | idxfrac |
+-------+-------+-------+------------+---------+
| 1.92m | 0.12g | 0.00g | 0.12g      |    0.01 |
+-------+-------+-------+------------+---------+

C:\wamp64\bin\mysql\mysql5.7.19\my
    [client]
    ;password =
    port = 3306
    socket = /tmp/mysql.sock

    [wampmysqld64]
    ;skip-grant-tables
    port = 3306
    socket = /tmp/mysql.sock
    key_buffer_size = 64M
    max_allowed_packet = 1M
    ;Added to reduce memory used (minimum is 400)
    table_definition_cache = 600
    sort_buffer_size = 10G
    net_buffer_length = 8K
    read_buffer_size = 2M
    read_rnd_buffer_size = 2M
    myisam_sort_buffer_size = 32M
    ;Path to mysql install directory
    basedir="c:/wamp64/bin/mysql/mysql5.7.19"
    log-error="c:/wamp64/logs/mysql.log"
    ;Verbosity Value 1 Errors only, 2 Errors and warnings , 3 Errors, warnings, and notes
    log_error_verbosity=2
    ;Path to data directory
    datadir="c:/wamp64/bin/mysql/mysql5.7.19/data"

And from the command prompt:

c:\Users\AmandaJ>systeminfo
    Host Name: MYXPS
    OS Name: Microsoft Windows 10
    OS Version: 10.0.15063 N/A Build 15063
    System Model: XPS 15 9560
    System Type: x64-based PC
    Processor(s): 1 Processor(s) Installed.
      [01]: Intel64 Family 6 Model 158 Stepping 9 GenuineIntel ~2801 Mhz
    BIOS Version: Dell Inc. 1.5.0, 30-Aug-17
    Total Physical Memory: 16,236 MB
    Available Physical Memory: 10,535 MB
    Virtual Memory: Max Size: 18,668 MB
    Virtual Memory: Available: 11,839 MB
    Virtual Memory: In Use: 6,829 MB

    Page File Location(s): C:\pagefile.sys

    Domain: POSSBIL
    Logon Server: \\MYXPS

I also modified the websites db.inc.php to reflect the test user name and password and tried the test.php file again -same error.

I can log into phpmyadmin as "test" user, but the only database listed is information_schema

Options: ReplyQuote


Subject
Written By
Posted
Re: Error Connecting to DataBase!: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
October 07, 2017 09:40PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.