Control Web Panel

WebPanel => MySQL => Topic started by: Nagataka on July 12, 2015, 08:05:35 AM

Title: Creating new databases & users
Post by: Nagataka 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
Title: Re: Creating new databases & users
Post by: Administrator on July 13, 2015, 06:57:21 PM
do you get any error message ?
Title: Re: Creating new databases & users
Post by: Nagataka 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.
Title: Re: Creating new databases & users
Post by: Nagataka 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. :)
Title: Re: Creating new databases & users
Post by: kolawole 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?
Title: Re: Creating new databases & users
Post by: harbind 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.
Title: Re: Creating new databases & users
Post by: Igor S. on January 07, 2016, 06:13:27 AM
Hello, all.

Yes, you can add a databases via console.
Title: Re: Creating new databases & users
Post by: crmgddn63 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
Title: Re: Creating new databases & users
Post by: crmgddn63 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
Title: Re: Creating new databases & users
Post by: tiagondelgado on April 02, 2018, 09:46:19 PM
Have the same problem...
Title: Re: Creating new databases & users
Post by: turkoy on April 07, 2018, 05:12:15 PM
same problem
new database user permissions are not added.
and no login
Title: Re: Creating new databases & users
Post by: belrpr 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.
Title: Re: Creating new databases & users
Post by: blakilox 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
Title: Re: Creating new databases & users
Post by: Imago 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.
Title: Re: Creating new databases & users
Post by: josemnunez on October 05, 2018, 11:07:19 AM
must check that the options allowed in the api key are correct
Title: Re: Creating new databases & users
Post by: CWP Lovers on August 09, 2020, 02:45:51 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.

AWESOME!

you solve my problem with this simple solution! Thanks!