Score:0

I was trying to remove password for the root user of mysql permanently. Got stuck with the below mentioned error

az flag

I typed below commands in cmd prompt.

sudo systemctl stop mysql.service
sudo systemctl status mysql.service

Error: Unable to type anything and stuck with lines 1-13/13(END) What to do next?

  1. If I want to create an user account for any services and give them complete permissions for a single database of those services only. Don't want to use root account. How can it be possible to do?
vanadium avatar
cn flag
Edit your post to make both title and question more clear. This is apparently about the root account of mysql, and not about the root account of the Ubuntu system?
Pikaschu avatar
az flag
What's the difference between root account of mysql and root account of Ubuntu system?
Organic Marble avatar
us flag
What 'steps' are you asking about in part 1? You're showing what looks like the output from a status query. There are no 'steps' in the output.
Pikaschu avatar
az flag
https://linuxhint.com/change-mysql-root-password-ubuntu/ I have applied using the URL instructions till STEP-3. After which I cannot able to proceed. Either I want to exit out of cmd prompt but I can't type anything in cmd prompt or need to complete the tasks as mentioned in the URL but still hanging over there.
Organic Marble avatar
us flag
No one here can know what instructions you were trying to execute. You have now provided a link, but it's unreasonable to expect people to go read that link and figure out what you did. Edit your question, show the command you input, and its output. Do not post screenshots, edit the text in. If you are really asking just how to get out of that status screen, you just type "q".
Score:-1
us flag

Your question is a bit confusing... since you say you want to create a user for "any kind of services" but, then that the user should only have permissions to one particular database..

Assuming you're just looking to not type in a pw each time you start SQL, then you may be able to modify the folder that SQL is in with the info in the first 5 paragraphs of this page...

https://smallbusiness.chron.com/give-permissions-ubuntu-33174.html

Pikaschu avatar
az flag
The 1st question is bit important. How to resolve the issue after ```END```?
Liso avatar
sd flag
@PKS21 If you want to exit from that prompt, just press *Q* on keyboard.
Greenonline avatar
us flag
Link only answer
Pikaschu avatar
az flag
@Greenonline which link?
Pikaschu avatar
az flag
@Liso Will it be a problem or crash to the system, If I press Q?
Liso avatar
sd flag
@PKS21 From your picture, I think you only toggle service status, shouldn't be a problem at all then.
Pikaschu avatar
az flag
@Liso It's fine now when I pressed Q. Can you let me know about the 2nd point and the difference between root user in ```mysql``` and root account in ```ubuntu```?
ru flag
@PKS21 completely independent of each other. MySQL root user is admin for MySQL. `root` in Linux is the superuser who can do pretty much anything on the system (and is disabled by default in Ubuntu in lieu of the use of `sudo` by admins instead)
Pikaschu avatar
az flag
@ThomasWard Thank you.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.