Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto | Site FAQ | Sitemap | Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
 |
Introduction to Linux — A Hands on Guide |
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author’s experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
I am creating a db in mysql for a java program.My program works well in my friends system.But I have some problem with my mysql.
The query is below:
I cant create any user for my db.Please help??
8 Answers 8
My solution was to run
Scenario: I updated the MySQL version on my Mac with ‘homebrew upgrade’. Afterwards, some stuff worked, but other commands raised the error described in the question.
Looks like something is messed up with your MySQL installation. The mysql.user table should definitely exist. Try running the command below on your server to create the tables in the database called mysql :
If that doesn’t work, maybe the permissions on your MySQL data directory are messed up. Look at a "known good" installation as a reference for what the permissions should be.
You could also try re-installing MySQL completely.
Your database may be corrupt. Try to check if mysql.user exists:
If these are missing you can try recreating the tables by using
or you may have to clean (completely remove it) and reinstall MySQL.
Если сразу после установки MariaDB попытаться запустить её службу, то служба не запустится. При проверке статуса:
Будет показано сразу несколько ошибок и предупреждений:
- [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
- [Warning] Failed to load slave replication state from table mysql.gt > В журнале systemd:
будут примерно следующие сообщения:
Причина ошибки в том, что отсутствуют технические таблицы, необходимые для нормального функционирования MariaDB.
Чтобы исправить проблему, запустите создание установку необходимых баз данных:
После этого можно запускать службу:
Также рекомендуется запустить команду, которая выполнит действия, направленные на усиления безопасности СУБД MariaDB: