PHP Classes
elePHPant
Icontem

Laravel Nova PHP MySQL Manager: Web interface for MySQL server management

Recommend this page to a friend!
  Info   View files Documentation   Screenshots Screenshots   View files View files (17)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2019-02-19 (6 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 131 All time: 8,925 This week: 332Up
Version License PHP version Categories
nova-mysql 1.0.0Custom (specified...5PHP 5, Databases, Systems administration
Description Author

This package provides a Web interface for MySQL server management.

It is a component for Laravel Nova administration interface that allows uses to perform several tasks to manage a MySQL server. Currently it allows:

- Create and manage MySQL databasases
- Managing MySQL user passwords
- Grant users privileges to execute certain SQL operations
- Etc..

Innovation Award
PHP Programming Innovation award nominee
April 2019
Number 9
MySQL is a very popular database server used by many PHP applications.

However, when you want to perform administrative tasks like managing database, users and privileges, usually you need to use specific command line utility programs that come with MySQL server distribution, or use programs that provide a Web interface to perform those tasks.

This package provides a Web interface to perform MySQL server management task within an administration panel managed using Laravel Nova.

Manuel Lemos
  Performance   Level  
Name: Naif Alshaye <contact>
Classes: 20 packages by
Country: Saudi Arabia Saudi Arabia
Age: ???
All time rank: 23669 in Saudi Arabia Saudi Arabia
Week rank: 93 Up1 in Saudi Arabia Saudi Arabia Up
Innovation award
Innovation award
Nominee: 6x

 

Details

Laravel Nova MySQL Server Managment

Laravel Nova MySQL Server Management to do: - Create new database - Delete database - Repair database - Add new user - Delete user - Change user password - Add user to database - Revokes user from database

Installation

You can install the package in to a Laravel app that uses Nova via composer:

composer require naif/nova-mysql

Usage:

Add the below to app/Providers/NovaServiceProvder.php

public function tools()
  {
      return [
           new NovaMysql()
      ];
  } 

Add the below to your .env file

CPANEL_HOST=YOUR_CPANEL_HOST_IP
CPANEL_DOMAIN=YOUR_DOMAIN_WITHOUT_HTTPS
CPANEL_PORT=MYSQL_PORT default 2083
CPANEL_USERNAME=YOUR_WEB_HOSTING_USERNAME
CPANEL_PASSWORD=YOUR_WEB_HOSTING_PASSWORD
CPANEL_PREFIX=YOUR_CPANEL_PREFIX prefix_DatabaseName

Screenshots

<img src="https://raw.githubusercontent.com/naifalshaye/nova-mysql/master/screenshots/first.png" width="700">

<img src="https://raw.githubusercontent.com/naifalshaye/nova-mysql/master/screenshots/second.png" width="700">

<img src="https://raw.githubusercontent.com/naifalshaye/nova-mysql/master/screenshots/third.png" width="700">

<img src="https://raw.githubusercontent.com/naifalshaye/nova-mysql/master/screenshots/fourth.png" width="700">

<img src="https://raw.githubusercontent.com/naifalshaye/nova-mysql/master/screenshots/fifth.png" width="700">

<img src="https://raw.githubusercontent.com/naifalshaye/nova-mysql/master/screenshots/six.png" width="700">

Support:

naif@naif.io

https://www.linkedin.com/in/naif

License:

The MIT License (MIT). Please see License File for more information.

Screenshots  
  • screenshots/six.png
  • screenshots/third.png
  • screenshots/second.png
  • screenshots/fourth.png
  • screenshots/first.png
  • screenshots/fifth.png
  Files folder image Files  
File Role Description
Files folder imagedist (2 directories)
Files folder imageresources (3 directories)
Files folder imageroutes (1 file)
Files folder imagesrc (2 files, 1 directory)
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file mix-manifest.json Data Auxiliary data
Accessible without login Plain text file package.json Data Auxiliary data
Accessible without login Plain text file README.md Doc. Documentation
Accessible without login Plain text file webpack.mix.js Data Auxiliary data

  Files folder image Files  /  dist  
File Role Description
Files folder imagecss (1 file)
Files folder imagejs (1 file)

  Files folder image Files  /  dist  /  css  
File Role Description
  Accessible without login Plain text file tool.css Data Auxiliary data

  Files folder image Files  /  dist  /  js  
File Role Description
  Accessible without login Plain text file tool.js Data Auxiliary data

  Files folder image Files  /  resources  
File Role Description
Files folder imagejs (1 file, 1 directory)
Files folder imagesass (1 file)
Files folder imageviews (1 file)

  Files folder image Files  /  resources  /  js  
File Role Description
Files folder imagecomponents (1 file)
  Accessible without login Plain text file tool.js Data Auxiliary data

  Files folder image Files  /  resources  /  js  /  components  
File Role Description
  Accessible without login Plain text file Tool.vue Data Auxiliary data

  Files folder image Files  /  resources  /  sass  
File Role Description
  Accessible without login Plain text file tool.scss Data Auxiliary data

  Files folder image Files  /  resources  /  views  
File Role Description
  Accessible without login Plain text file navigation.blade.php Aux. Auxiliary script

  Files folder image Files  /  routes  
File Role Description
  Accessible without login Plain text file api.php Aux. Auxiliary script

  Files folder image Files  /  src  
File Role Description
Files folder imageHttp (2 directories)
  Plain text file NovaMysql.php Class Class source
  Plain text file ToolServiceProvider.php Class Class source

  Files folder image Files  /  src  /  Http  
File Role Description
Files folder imageControllers (1 file)
Files folder imageMiddleware (1 file)

  Files folder image Files  /  src  /  Http  /  Controllers  
File Role Description
  Plain text file cPanelController.php Class Class source

  Files folder image Files  /  src  /  Http  /  Middleware  
File Role Description
  Plain text file Authorize.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:131
This week:0
All time:8,925
This week:332Up