menu
  • Register

Want to solve programming problems and get paid for it? If that sounds interesting to you then contact us.

Fatal error: can't open and lock privilege tables: table 'mysql.user' doesn't exist

0 votes
551 views

Problem :

I have very recently installed the MySQL community server 5.7.10 using binary zip. I have also extracted the zip in the c:\mysql and created my data folder in c:\mysql\data. I have also  created the config file as my.ini and placed it in the  c:\mysql in the root folder of the extracted zip. Following is the content of the my.ini file:

# set basedir to your installation path
basedir=C:\mysql
# set datadir to the location of your data directory
datadir=C:\mysql\data

I want to start MySQL using mysqld --console, but the process is often aborted with the following error message :

2019-12-14T18:04:01.141930Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-12-14T18:04:01.141930Z 0 [ERROR] Aborting

Please let me know if you have any solution on above error message.

●6 ●5 ●3
7,540 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

On the Maria DB please use mysql_install_db. In my case I tried to use the environment variable for my data path. Not only does the mysqld need to know where your data is and it is specified via commandline, but so does your install script.

Below is the way you can call the install script specifying your datapath:

mysql_install_db --user=root --datadir=$db_datapath

 

Hope it resolves your issue.

●9 ●7 ●4
38,600 points

Related questions

0 votes
1 answer 2.4K views
2.4K views
Fatal error c1083: cannot open include file: 'mysql.h': no such file or directory
Problem : Following is my issue: I tried to install mysqlclient like below : C:\Users\alecxe>pip install mysqlclient Collecting mysqlclient Using cached https://files.pythonhosted.org/packages/ec/fd/83329b9d3e14f7344d1 cb31f128e6dbba70c5975c9e57896815dbb1988ad/mysqlclient-1.3.13.tar.gz Installed ... beginner to this and would be very happy if any input as to how to go about fixing above error.
asked Dec 27, 2019 alecxe 7.5k points
0 votes
1 answer 45 views
45 views
#1932 - table 'phpmyadmin.pma__tracking' doesn't exist in engine
Problem: When i try to setup my databse using xampp phpmyadmin i am getting an 1932 error table 'phpmyadmin.pma__tracking' doesn't exist in engine. I need assistance how can we overcome this error.
asked Nov 13, 2020 prog_learner 2.5k points
0 votes
2 answers 776 views
776 views
fatal python error: py_initialize: unable to get the locale encoding
Problem : On installing Anaconda on Ubantu getting below Python error on miss-typed commands fatal python error: py_initialize: unable to get the locale encoding
asked Oct 21, 2019 peterlaw 6.9k points
0 votes
1 answer 21 views
21 views
how to search and filter data in html table using php and mysql database [ with source code ]
Issue: I have a project in mysql and php. It works but the thing is that it will keep on refeshing when I select the name. Also, it is so cumbersome to keep on clicking the submit button. Is there anyway to solve my issue that whenever I select the member's name, the table will refresh itself ... thead>     <tbody>         <tr>             <?php echo $table; ?>         </tr>     </tbody> </table> 
asked Oct 31, 2020 RJ Lam 650 points
0 votes
1 answer 13 views
13 views
php code to retrieve data from mysql database and display in html table
Hi, I have a small php project. I need a php class that will enable me to retrieve the information from a database so that I can display in a table as shown in this html code: <!DOCTYPE html> <html> <head> <title>List of Cars</title> </head> <body> <table> <tr> <th>Year</th> <th>Brand</ ... >AUDI Q2 2020</td> </tr> <tr> <td>2020</td> <td>Volvo</td> <td>Xc60 2020</td> </tr> </table> </body> </html>
asked Oct 11, 2020 azriel 590 points
0 votes
1 answer 17 views
17 views
how to fetch data from two tables in mysql using php
Problem: I have two tables that I am working on. One is the list of items and the other is the list of sales per item. And I want to see the sales of an item that I selected from the dropdown list. This is a portion of the table: id item_name item_qty ... Pen's particulars to be displayed above the table. I'm wondering whether this can be done with the static page though it is a php project.
asked Nov 1, 2020 RJ Lam 650 points
0 votes
1 answer 16 views
16 views
how to fetch data from two tables in mysql without join
Problem: I have a PHP project that requires me to access two tables. But I don't want to join them because I need to update the main table and then, update/create the second table. Anyone who has a sample code that will allow me to independently fetch the two tables without actually joining them?
asked Oct 31, 2020 RJ Lam 650 points
0 votes
1 answer 110 views
110 views
The mysql server is running with the --skip-grant-tables option so it cannot execute this statement
Problem : I am very new to the Linux but want to set up my MySQL databases on the Amazon ec2 instance. I have followed some directions I found about resetting a user login pass by using a --skip-grant-tables option of the MySQL. Now I want to add my user ... HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement How can I turn above option off?
asked Jan 30, 2020 jwilliam 3.9k points
0 votes
1 answer 19 views
19 views
Column count doesn't match value count at row 1 mysql
Problem: Hi, I am new to php database operations. i have written the query and it shows the error column count doesn't match value count at row 1 mysql. INSERT INTO Student VALUES ('Name', 'last name''class');
asked Nov 16, 2020 prog_learner 2.5k points
1 vote
1 answer 25 views
25 views
Can't connect to local mysql server through socket '/tmp/mysql.sock'.
Problem : I am very new to MySQL Server. I am newly assigned to this MySQL Server project. If I try to connect with the local MySQL server during my assigned test suite it shows me the below error: "Can't connect to local MySQL server through socket '/tmp/ ... that exception I can connect with my exact same parameters. I am very confused about above error. Can some expert help me in fixing it?
asked Apr 8, 2020 morrisBson 3.2k points
Dark theme