toggle menu

Create database with "No Privileges issues" on digitalocean LEMP server

Dhananjay Kumar |04 Oct at 12:10

We have find the solution with below steps:
Go with Access Command prompt
Run:

# sudo mysql

mysql > GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';

mysql> exit;

 

And  For specified database:

GRANT ALL ON databasename TO 'username'@'localhost';

Hope help you lots.

 

 

 

  • 1 like
  • 0 comment

nxn

Immwit work |12 Dec at 01:12

nxnx

  • 0 like
  • 0 comment

When installing phpmyadmin on LEMP nginx server, getting error path not found

Dhananjay Kumar |24 Mar at 02:03

I am installing phpmyadmin on nginx server (LEMP) and running below Command getting issues :

sudo ln -s /usr/share/phpmyadmin /usr/share/nginx/html

Please any one help me...

  • 1 like
  • 1 comment

Dhanavi29 Mar at 06:03

I am getting the same issues, just change in path and run code
sudo ln -s /usr/share/phpmyadmin /var/www/html

413 Request Entity Too Large on nginx server

Dhananjay Kumar |24 Mar at 07:03

Please any one help with this issues, when i am importing xyz.sql from phpmyadmin( file size 180MB), getting 413 Request Entity Too Large  issues on nginx server.

We have updated parameter in php.ini below:
upload_max_filesize, memory_limit and post_max_size with max size of changes.

If any one have solution confirm asap.

  • 2 likes
  • 0 comment