Author Topic: Creating new databases & users  (Read 3645 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

Online
*
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.

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