PHP Classes

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

Recommend this page to a friend!
  Info   Documentation   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 155 All time: 9,027 This week: 61Up
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
Picture of Naif Alshaye
  Performance   Level  
Name: Naif Alshaye <contact>
Classes: 24 packages by
Country: Saudi Arabia Saudi Arabia
Age: ???
All time rank: 18576 in Saudi Arabia Saudi Arabia
Week rank: 192 Up2 in Saudi Arabia Saudi Arabia Up
Innovation award
Innovation award
Nominee: 9x

Documentation

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 (6)  
  • screenshots/fifth.png
  • screenshots/first.png
  • screenshots/fourth.png
  • screenshots/second.png
  • screenshots/six.png
  • screenshots/third.png
  Files folder image Files (23)  
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 (23)  /  dist  
File Role Description
Files folder imagecss (1 file)
Files folder imagejs (1 file)

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

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

  Files folder image Files (23)  /  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 (23)  /  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 (23)  /  resources  /  js  /  components  
File Role Description
  Accessible without login Plain text file Tool.vue Data Auxiliary data

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

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

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

  Files folder image Files (23)  /  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 (23)  /  src  /  Http  
File Role Description
Files folder imageControllers (1 file)
Files folder imageMiddleware (1 file)

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

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:155
This week:0
All time:9,027
This week:61Up