Grants not working
I have a LAMP for web site development and rarely need to touch the database admin stuff.
It has been years. I am creating a new site with database but I can't get the user to have privileges.
Can anyone spot what is wrong?
So I connect to the server with:
stephen@Avalon:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.26-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
===========================================
I create grants
mysql> grant all on rois3324_stephen.* to "rois3324_stephen"@"localhost" with grant option;
Query OK, 0 rows affected (0.00 sec)
===========================================
I try to see grants
mysql> "rois3324_stephen"@"localhost"
->
It looks like no grants were created. And I get a confirming error from PHP.
Can anyone see what is wrong?
Thank you!
--
Stephen
Subject
Written By
Posted
Grants not working
May 28, 2019 06:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.