3,019 reputation
11238
bio website
location
age
visits member for 3 years, 6 months
seen Mar 26 at 18:55

Feb
12
awarded  Notable Question
Jan
14
reviewed Approve startup mount issues with Oracle
Jan
14
reviewed Approve MYSQL: Join with many to many
Jan
13
comment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Find the mysqld in your processlist. Run sudo lsof -p PID where PID is the process id of your mysqld process. This should show you file handles it has open
Jan
13
comment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
See the link in my answer below on how to restore
Jan
13
answered ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Jan
13
comment ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Examine the source sql file you ran. Did it contain anything like a mysql.users table or any GRANT, set password or create user queries? It's possible you blew out your root account credentials with that.
Jan
12
comment Not able to solve issue: Incorrect string value: '\xC5\xABt\xC4\x97'
Try a hyphenated characterEncoding=utf-8 in your URL
Jan
12
comment Not able to solve issue: Incorrect string value: '\xC5\xABt\xC4\x97'
Does your JDBC URL have a characterEncoding=UTF8mb4 parameter? @TianyiCong
Jan
12
comment Not able to solve issue: Incorrect string value: '\xC5\xABt\xC4\x97'
Are the character encoding variables you pasted the session values from the same connection as the client connection that is experiencing the error?
Jan
9
reviewed Reject Speed inserts in database with a table with +47 million data per each year, containing more than 10 years?
Jan
9
reviewed Approve Database timestamp
Jan
9
reviewed Approve What is WITH QUERY EXPANSION MODE in MySQL Fulltext Search
Jan
7
reviewed Approve Error: Package ‘Microsoft SQL Server Management Studio Package’ failed to load
Jan
5
reviewed Approve Excel Spreadsheet Import to MySQL
Dec
29
awarded  Popular Question
Dec
10
comment Cannot Run SQL INSERT in MySQL
Also given his final version output it looks as though sudo is not required to just execute the mysql client.
Dec
9
reviewed Approve Do agile software development approaches apply to SQL?
Dec
6
awarded  Popular Question
Dec
5
reviewed Reject Sql Server 2012 Change Data Capture weird behaviour