Author Topic: Creating new databases & users  (Read 31401 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Creating new databases & users
« on: July 12, 2015, 08:05:35 AM »
Not sure if it is me..
Running CWP version: 0.9.8.8
Cannot add any databases/database users through the system?
I was able todo this before.

Of course i can do this manually, but would be nice if it would work through the GUI

Offline
*
Re: Creating new databases & users
« Reply #1 on: July 13, 2015, 06:57:21 PM »
do you get any error message ?
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: Creating new databases & users
« Reply #2 on: July 14, 2015, 05:24:58 PM »
No error at all.
I go to SQL Services -> MySQL manager -> Create database and user:
Data Entered
================================
Database: orimaenl_typo3
Username: orimaenl_typo3
Password: <pass>

After that went to list databases & users, is empty.

Go to create only a database, says database is created.

Next thing, i login into putty.
Code: [Select]
[orimaenl@localhost ~]$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 71
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| blabla             |
| mysql              |
| postfix            |
| root_cwp           |
| roundcube          |
| typo3              |
+--------------------+
8 rows in set (0.00 sec)


As you can see, databases could be created before, but not in this version.


[edit]
Doesn't matter from what user i create the database btw. I tried it from the root as well from the user account itself.
« Last Edit: July 14, 2015, 05:27:28 PM by Nagataka »

Offline
*
Re: Creating new databases & users
« Reply #3 on: July 15, 2015, 04:59:59 PM »
Sorry for my double post.
For now i need to continue with creating a database.
If i will create the database manually through the command line.
Will this impact CWP? Like, will i see the right database under the right user with right permissions and stuff?

[edit]
Done this, databases still not showing up in CWP, database works fine with the create user. :)
« Last Edit: July 15, 2015, 05:19:15 PM by Nagataka »

Offline
*
Re: Creating new databases & users
« Reply #4 on: November 28, 2015, 11:09:57 AM »
Hello:
I am a CWP newbie seem to be having the same issues posted on this thread. I did not seem to get if there was a resolution of the problem. The Mysql Manager displays blank page and one cannot create/list databases or users. Any help from anyone?

Offline
*
Re: Creating new databases & users
« Reply #5 on: December 10, 2015, 06:08:33 AM »
Also having the very same issue.  Seems to stem from updating mysql. Any help would be appreciated.

Offline
*****
Re: Creating new databases & users
« Reply #6 on: January 07, 2016, 06:13:27 AM »
Hello, all.

Yes, you can add a databases via console.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: Creating new databases & users
« Reply #7 on: September 15, 2016, 10:22:41 AM »
hello

how can i fix this ?  databases still not showing up in CWP, and i can not create, list and delete dbs.

thank you

Offline
*
Re: Creating new databases & users
« Reply #8 on: October 17, 2016, 09:24:38 PM »
hello,
nobody knows how can i fix this ? Running CWP version: 0.9.8.8
Cannot add any databases/database users through the system?
I was able todo this before.
Of course i can do this manually, but would be nice if it would work through the GUI.

thnak you

Offline
*
Re: Creating new databases & users
« Reply #9 on: April 02, 2018, 09:46:19 PM »
Have the same problem...

Offline
*
Re: Creating new databases & users
« Reply #10 on: April 07, 2018, 05:12:15 PM »
same problem
new database user permissions are not added.
and no login

Offline
*
Re: Creating new databases & users
« Reply #11 on: July 08, 2018, 12:22:50 PM »
Having the same issue but I can work around it by:

Creating a database only and then creating the user manually using the gui.

Offline
*
Re: Creating new databases & users
« Reply #12 on: August 09, 2018, 02:28:35 PM »
Same Issue
cannot use MySql Manager to create database
I click in "Create New Database" nothing happens
The above workaround didn't work for me
I am finding this when logged in as a general user

UPDATE
Ahhhh what I found is it wont accept the underscore character, then it works, there is no warning
« Last Edit: August 09, 2018, 02:42:45 PM by blakilox »

Offline
*
Re: Creating new databases & users
« Reply #13 on: October 04, 2018, 12:25:56 PM »
For fresh installed CWP, one should first create some client account with default package and only then the function of creating new db and new user to it works.

This doesn't qualify as bug but certainly is a glitch.

Offline
*****
Re: Creating new databases & users
« Reply #14 on: October 05, 2018, 11:07:19 AM »
must check that the options allowed in the api key are correct