Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

I'm getting an error when I ran mysql_secure_installation

J
Jolied last edited by

I keep getting the following error on running sudo mysql_secure_installation

... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.

Any help will be appreciated.
Reply Quote 0
1 Reply Last reply
K
Kadyn last edited by
Please follow below steps to fix the error.

Login as a root user without using any password
```
sudo mysql
```
Then use the following command to change the authentication parameter:
```
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'mynewpassword'
```
where mynewpassword is the new password you have set for root user, it would help to access and run installation again.

Run again mysql_secure_installation to secure MySQL
```
mysql_secure_installation
```
once asked, enter the new set password for root user you recently did.

Check for more details on https://dev.mysql.com/doc/internals/en/authentication-method.html ,https://dev.mysql.com/doc/dev/mysql-server/latest/page_protocol_connection_phase_authentication_methods.html
Reply Quote 0
1 Reply Last reply

mysql 49766

2
Posts

0
Views

Suggested Topics

D

823 errors on tempdb
SQL, Database Testing • sql server sql server 2005 tempdb • • derk

2

0
Votes

2
Posts

0
Views

R

First, if you're getting corruption issues in TempDB, I'd start by making sure I've got DBCC CHECKDB reporting clean results across my user databases. I'd also restore those backups on another server and run DBCC CHECKDB there just to make sure the problems are only confined to TempDB. Then I'd remove any filter drivers on the servers - antivirus, disk defragmenting, storage mirroring, etc - and try to run multiple load-intensive queries against TempDB to see if I can reproduce the issue. Do simple select-intos, dumping Cartesian joins of your user databases into TempDB. Finally, if I can get an outage window, I'd try SQLIO - not SQLIOSIM - hammering the TempDB drives. SQLIOSIM is interesting if you want to reproduce a vague similarity of a benchmark, but SQLIO is better if you just want to repeatedly punch your storage in the junk. Plus, it's really good about bubbling failures up quickly. You also asked: how much more likely is drive corruption than, say, I/O path driver issues (storport, HBA driver or firmware, filter drivers). In my experience, the most common corruption issues are connectivity problems, followed by storage processor/controller firmware bugs, followed by filter drivers (I see less only because they were so unreliable that most folks have uninstalled them), finally followed by drive corruption. After all, in modern storage, the RAID controllers are pretty good about catching problems with a single failing drive.
A

Withdrawal by Group of ASC records
Software Programming • mysql sql group by • • Anderson

2

0
Votes

2
Posts

0
Views

Z

this way:select id, is_read, amount from test group by amount, is_read order by amount, is_read limit 1 http://sqlfiddle.com/#!9/e5de99/4
A

Problem when trying to do a query with PHP and MYSQL
Software Programming • php mysql sql • • Avante

2

0
Votes

2
Posts

0
Views

Z

The problem is that you have twice seated the $this->conn:$this->conn = mysqli_connect($this->dbServer, $this->dbUser, $this->dbPassword) or die("Não foi possível estabelecer a conexão com a base de dados! ".mysqli_error($this->conn)); $this->conn = mysqli_select_db($this->conn, $this->dbName) or die("Não foi possível se conectar com o banco de dados! ".mysqli_error($this->conn)); It should be:$this->conn = mysqli_connect($this->dbServer, $this->dbUser, $this->dbPassword) or die("Não foi possível estabelecer a conexão com a base de dados! ".mysqli_error($this->conn)); mysqli_select_db($this->conn, $this->dbName) or die("Não foi possível se conectar com o banco de dados! ".mysqli_error($this->conn)); Yeah. $this->conn must be the result of mysqli_connect, since it will contain the "link", the function mysqli_select_db is just to exchange bank, actually you don't even need it, only if you want to exchange bank during execution, you can simplify for this:public function __construct(){ $this->conn = mysqli_connect($this->dbServer, $this->dbUser, $this->dbPassword, $this->dbName) or die("Não foi possível estabelecer a conexão com a base de dados! ".mysqli_error($this->conn)); $this->setQuery(); }
E

ORDER BY with IF-ELSE statement (DESC doesn't work)
SQL, Database Testing • php mysql phpmyadmin order by • • elysha

2

0
Votes

2
Posts

0
Views

A

Welcome. Please notice that you are in a wrong place. dba - here you can give your mysql code alone and ask for help. You might have asked this question in stackoverflow. Anyway here is what you miss. if(isset($_GET["sortfield"])){ is right. But if(isset($_GET["sorttype"]) == "asc"){ is not right as the expression to the left of equal condition operator would evaluate to true or false and if you check the logical value == "asc" it will fail. It should be if(isset($_GET["sorttype"]) and $_GET["sorttype"]== "asc"){ or simply if($_GET["sorttype"]== "asc"){ if you are sure that it is already set (as of the first if). Also, please go through this before asking. https://stackoverflow.com/help/minimal-reproducible-example If you had gone through the mentioned page, formatted your question clearly and asked at the right place, you would have got your answer on day one itself for sure.
C

Getting Error 10054 after renaming the server
SQL, Database Testing • sql server sql server 2014 connect • • courtlanda

2

0
Votes

2
Posts

0
Views

M

See the Microsoft Docs article Rename a Computer that Hosts a Stand-Alone Instance of SQL Server. You'll need to restart the SQL Server service, and use sp_dropserver / sp_addserver to update the server name within SQL Server.
How do you add SQL?
Software Programming • mysql sql database phpmyadmin • • Laycee

2

0
Votes

2
Posts

0
Views

E

You may disagree with me, but whatever you want to do is wrong. You probably don't understand much yet in the subject area and you want to solve the problem quickly. If you do so, you're not gonna do it when you insert it. And you can do it through the trigger.CREATE TRIGGER `my_super_trigger` before update ON `table_name` FOR EACH ROW BEGIN SET NEW.f = CONCAT(OLD.f, '|', NEW.f); END; I mean, theoretically, your goal is achievable, but it's not right to do so in your task. I mean, you have to do something differently, in a situation.PS A response from Timur Milovanov on INSERT INTO. ♪ ♪ ON DUPLICATE KEY UPDATE... even better!
N

An expression of non-boolean type specified in a context where a condition is expected, near 'AND'
SQL, Database Testing • sql server t sql syntax • • Nykeriab

2

0
Votes

2
Posts

1
Views

R

The problem is on this line: IF @StartDate AND @EndDate IS NOT NULL You're expecting this to be evaluated as: IF (@StartDate AND @EndDate) IS NOT NULL But the way SQL Server evaluates it is: IF (@StartDate) AND (@EndDate IS NOT NULL) So the error is that @StartDate is not a boolean expression, and cannot be used as part of the IF expression. Instead, you'll need to do something like: IF @StartDate IS NOT NULL AND @EndDate IS NOT NULL
O

MySQL: is it more efficient to query for duplicate row or insert(update) on duplicate?
SQL, Database Testing • mysql update insert best prac languagetic lan • • obi

2

0
Votes

2
Posts

0
Views

J

At 250/hour, all possible techniques are plenty fast. Anyway, I will throw my 2 cents in... Multi-row INSERT of 100 rows will run 10 times as fast as 100 individual INSERTs. Multi-row INSERT may lead to gaps in AUTO_INCREMENTs. In general, the command will preallocate all the ids it might need, then 'burn' the ones id did not use. (REPLACE burns lots, since it is DELETE + INSERT.) For efficient "normalization" do something like: INSERT IGNORE INTO HostNorm (host_name) SELECT DISTINCT s.host_name FROM Staging AS s LEFT JOIN HostNorm AS n ON n.host_name = s.host_name WHERE n.host_id IS NULL; A list of possibly new values is in Staging. HostNorm is where 'new' rows need to be put. Only 'new' rows are fed to INSERT (see LEFT JOIN). IGNORE is to accommodate having multiple threads (connections) doing similar inserts that could collide. (A rare collision would lead to a burned id.) There is no cap on how many rows this can handle. This works best with, say, 100 rows. This is designed for very high speed input; it should work fine for your relatively slow ingestion rate. More discussion in my blog.
D

CU8 for 2016SP2 error
SQL, Database Testing • sql server sql server 2016 upgrade patc languagehing • • Duquan

2

0
Votes

2
Posts

0
Views

K

The process does not possess the 'SeSecurityPrivilege' privilege which is required for this operation. That's pretty cut and dry. Even if you're in the Administrators local group (which you should be to run setup) things like group policy can still be going on in the background and locking things down. All of the required permissions are not held by the account used. which resulted in HResult : 0x80070005 which, when translated, means ERROR_ACCESS_DENIED. I would run repair on the installation to make sure everything is good and the perf counters show up and work without issue.
C

Is the database design alright? And I'm quite lost with the admin entity here
SQL, Database Testing • database design erd • • courtlanda

2

0
Votes

2
Posts

1
Views

A

Authentication and authorization for the administration logic should be handled by the application, so it is natural that the Admin entity will feel disconnected to your domain. You could expand into other entities, such as Permission and Group, so you can have fine-grained control over what exact permissions an administrator, or group of administrators, can have. Enforcing those, however, will be on the application side. The rest of your design looks pretty coherent. Keep it up!
F

how to find the error description for the error codes found in the extended events file XEL generated by SSAS Tabular query end event
SQL, Database Testing • ssas extended events • • fbio

2

0
Votes

2
Posts

1
Views

I think you should look at the [TextData] field. Based on Microsoft doc here: https://docs.microsoft.com/en-us/analysis-services/trace-events/errors-and-warnings-events-data-columns?view=asallproducts-allversions it should contain the the text data associated with the error event, like the error message. please, try this against your trace file. SELECT xe_file.[FILE_NAME] AS [filepath] ,[ApplicationName] = xe_file.xml_data.value('(/event/data[@name=''ApplicationName'']/value)[1]','[nvarchar](128)') ,[BinaryData] = xe_file.xml_data.value('(/event/data[@name=''BinaryData'']/value)[1]','[varbinary](max)') ,[ConnectionID] = CAST(xe_file.xml_data.value('(/event/data[@name=''ConnectionID'']/value)[1]','[nvarchar](128)') AS INT) ,[CPUTime] = CAST(xe_file.xml_data.value('(/event/data[@name=''CPUTime'']/value)[1]','[nvarchar](128)') AS bigint) ,[CurrentTime] = CAST(xe_file.xml_data.value('(/event/data[@name=''CurrentTime'']/value)[1]','[nvarchar](128)') AS DATETIME2) ,[DatabaseName] = xe_file.xml_data.value('(/event/data[@name=''DatabaseName'']/value)[1]','[nvarchar](128)') ,[Duration] = xe_file.xml_data.value('(/event/data[@name=''Duration'']/value)[1]','[nvarchar](128)') ,[EndTime] = xe_file.xml_data.value('(/event/data[@name=''EndTime'']/value)[1]','[nvarchar](128)') ,[Error] = CAST(xe_file.xml_data.value('(/event/data[@name=''Error'']/value)[1]','[nvarchar](128)') AS INT) ,[EventClassId] = CAST(xe_file.xml_data.value('(/event/data[@name=''EventClass'']/value)[1]','[nvarchar](128)') AS INT) ,[EventSubclassId] = CAST(xe_file.xml_data.value('(/event/data[@name=''EventSubclass'']/value)[1]','[nvarchar](128)') AS INT) ,[IntegerData] = CAST(xe_file.xml_data.value('(/event/data[@name=''IntegerData'']/value)[1]','[nvarchar](128)') AS INT) ,[JobID] = CAST(xe_file.xml_data.value('(/event/data[@name=''JobID'']/value)[1]','[nvarchar](128)') AS INT) ,[NTCanonicalUserName] = xe_file.xml_data.value('(/event/data[@name=''NTCanonicalUserName'']/value)[1]','[nvarchar](128)') ,[ObjectID] = xe_file.xml_data.value('(/event/data[@name=''ObjectID'']/value)[1]','[nvarchar](128)') ,[ObjectName] = xe_file.xml_data.value('(/event/data[@name=''ObjectName'']/value)[1]','[nvarchar](128)') ,[ObjectPath] = xe_file.xml_data.value('(/event/data[@name=''ObjectPath'']/value)[1]','[nvarchar](128)') ,[ObjectReference] = xe_file.xml_data.value('(/event/data[@name=''ObjectReference'']/value)[1]','[nvarchar](128)') ,[ObjectType] = CAST(xe_file.xml_data.value('(/event/data[@name=''ObjectType'']/value)[1]','[nvarchar](128)') AS INT) ,[ProgressTotal] = CAST(xe_file.xml_data.value('(/event/data[@name=''ProgressTotal'']/value)[1]','[nvarchar](128)') AS INT) ,[ServerName] = xe_file.xml_data.value('(/event/data[@name=''ServerName'']/value)[1]','[nvarchar](128)') ,[SessionID] = xe_file.xml_data.value('(/event/data[@name=''SessionID'']/value)[1]','[nvarchar](50)') ,[SessionType] = xe_file.xml_data.value('(/event/data[@name=''SessionType'']/value)[1]','[nvarchar](128)') ,[Severity] = CAST(xe_file.xml_data.value('(/event/data[@name=''Severity'']/value)[1]','[nvarchar](128)') AS INT) ,[SPID] = CAST(xe_file.xml_data.value('(/event/data[@name=''SPID'']/value)[1]','[nvarchar](128)') AS INT) ,[StartTime] = CAST(xe_file.xml_data.value('(/event/data[@name=''StartTime'']/value)[1]','[nvarchar](128)') AS DATE) ,[Success] = CAST(xe_file.xml_data.value('(/event/data[@name=''Success'']/value)[1]','[nvarchar](128)') AS INT) ,[TextData] = xe_file.xml_data.value('(/event/data[@name=''TextData'']/value)[1]','[nvarchar](max)') FROM ( SELECT [FILE_NAME] ,[XML_DATA] = CONVERT(XML, EVENT_DATA) FROM sys.fn_xe_file_target_read_file(@trace_filepath, NULL, NULL, NULL) ) AS xe_file ;
S

MySQL Syntax error when trying to create database trigger
SQL, Database Testing • mysql trigger • • Saumya

2

0
Votes

2
Posts

0
Views

R

ENDIF; END$$ DELIMITER; --> END IF; END $$ DELIMITER ; END IF is 2 words. Have a space before the delimiter.
Z

Replicación Master / slave - MySql
SQL, Database Testing • mysql replication • • zymir

2

0
Votes

2
Posts

0
Views

P

Find the flowchart that explains what happens when you have a mixture of binlog_do_... and binlog_ignore_... -- it is not necessarily what you would expect. Be aware that USE db1; INSERT INTO db2.tbl uses db1, not db2 for determining whether to replicate. Which binlog format are you using? For further debugging, use mysqldumpbinlog to see if a particular row was inserted into the binlog file on the Master and/or whether it arrived in the relay-log file on the Slave.
R

mySQL throws error, but if copied from error message or die() into phpmyadmin it works
SQL, Database Testing • mysql stored procedure errors • • rielyn

2

0
Votes

2
Posts

0
Views

T

It looks like you are having trouble executing multiple lines of SQL inside the one string. You need to find out of PHP Class can handle running multiple lines. Instead of getting the SQL to run dynamic SQL, just execute it yourself $sql = 'SELECT IF( (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = "' . $this->t($table) . '" AND table_schema = DATABASE() AND column_name = "' . $column . '" ) > 0, "SELECT 1;", "ALTER TABLE ' . $this->t($table) . ' ADD ' . $column . ' ' . $params . ';")'; Execute this one line, take that resulting string, and execute that. Hey, it may means running two SQL commands, but it will work. An alternative would be to write a stored procedure with that code and then call the stored procedure. Please look at my answer to the post MySQL: Create index If not exists where I used dynamic SQL to create an index if an index does not exist. You could frame a stored procedure for yourself and call it from PHP.
Sql selection without repetition
Software Programming • mysql group by • • Demir

2

0
Votes

2
Posts

0
Views

Thank you.SELECT client_id, MAX(date_over) FROM crm.calls WHERE user_id = 1 GROUP BY client_id;

I'm getting an error when I ran mysql_secure_installation

Suggested Topics

823 errors on tempdb SQL, Database Testing • sql server sql server 2005 tempdb • • derk

Withdrawal by Group of ASC records Software Programming • mysql sql group by • • Anderson

Problem when trying to do a query with PHP and MYSQL Software Programming • php mysql sql • • Avante

ORDER BY with IF-ELSE statement (DESC doesn't work) SQL, Database Testing • php mysql phpmyadmin order by • • elysha

Getting Error 10054 after renaming the server SQL, Database Testing • sql server sql server 2014 connect • • courtlanda

How do you add SQL? Software Programming • mysql sql database phpmyadmin • • Laycee

An expression of non-boolean type specified in a context where a condition is expected, near 'AND' SQL, Database Testing • sql server t sql syntax • • Nykeriab

MySQL: is it more efficient to query for duplicate row or insert(update) on duplicate? SQL, Database Testing • mysql update insert best prac languagetic lan • • obi

CU8 for 2016SP2 error SQL, Database Testing • sql server sql server 2016 upgrade patc languagehing • • Duquan

Is the database design alright? And I'm quite lost with the admin entity here SQL, Database Testing • database design erd • • courtlanda

how to find the error description for the error codes found in the extended events file XEL generated by SSAS Tabular query end event SQL, Database Testing • ssas extended events • • fbio

MySQL Syntax error when trying to create database trigger SQL, Database Testing • mysql trigger • • Saumya

Replicación Master / slave - MySql SQL, Database Testing • mysql replication • • zymir

mySQL throws error, but if copied from error message or die() into phpmyadmin it works SQL, Database Testing • mysql stored procedure errors • • rielyn

Sql selection without repetition Software Programming • mysql group by • • Demir

823 errors on tempdb
SQL, Database Testing • sql server sql server 2005 tempdb • • derk

Withdrawal by Group of ASC records
Software Programming • mysql sql group by • • Anderson

Problem when trying to do a query with PHP and MYSQL
Software Programming • php mysql sql • • Avante

ORDER BY with IF-ELSE statement (DESC doesn't work)
SQL, Database Testing • php mysql phpmyadmin order by • • elysha

Getting Error 10054 after renaming the server
SQL, Database Testing • sql server sql server 2014 connect • • courtlanda

How do you add SQL?
Software Programming • mysql sql database phpmyadmin • • Laycee

An expression of non-boolean type specified in a context where a condition is expected, near 'AND'
SQL, Database Testing • sql server t sql syntax • • Nykeriab

MySQL: is it more efficient to query for duplicate row or insert(update) on duplicate?
SQL, Database Testing • mysql update insert best prac languagetic lan • • obi

CU8 for 2016SP2 error
SQL, Database Testing • sql server sql server 2016 upgrade patc languagehing • • Duquan

Is the database design alright? And I'm quite lost with the admin entity here
SQL, Database Testing • database design erd • • courtlanda

how to find the error description for the error codes found in the extended events file XEL generated by SSAS Tabular query end event
SQL, Database Testing • ssas extended events • • fbio

MySQL Syntax error when trying to create database trigger
SQL, Database Testing • mysql trigger • • Saumya

Replicación Master / slave - MySql
SQL, Database Testing • mysql replication • • zymir

mySQL throws error, but if copied from error message or die() into phpmyadmin it works
SQL, Database Testing • mysql stored procedure errors • • rielyn

Sql selection without repetition
Software Programming • mysql group by • • Demir