cannot create database

hi
when i try to create a database i get

--
Cannot create database. Error message: 0
--

i have followed this, but it didn't help

https://forums.cyberpanel.net/discussion/171/some-donts-after-installing-cyberpanel



please help, i'm trying to move my site from cpanel to cyberpanel and need database.

Comments

  • Did you change mysql root password? Are you trying to restore old database or create new one?
  • Yes i have changed mysql root password and i'm trying to make new db.

    here is what i get

    --

    [[email protected] public_html]# cat /etc/cyberpanel/mysqlPassword
    9aO3z2DkEg9e6v[[email protected] systemctl status mysql -l
    ● mariadb.service - MariaDB 10.2.19 database server
    Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
    └─migrated-from-my.cnf-settings.conf
    Active: active (running) since Sat 2018-12-15 10:50:53 EST; 6min ago
    Docs: man:mysqld(8)
    https://mariadb.com/kb/en/library/systemd/
    Process: 16899 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 16855 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
    Process: 16853 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Main PID: 16867 (mysqld)
    Status: "Taking your SQL requests now..."
    CGroup: /system.slice/mariadb.service
    └─16867 /usr/sbin/mysqld

    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139951223650496 [Note] InnoDB: 5.7.24 started; log sequence number 3298366
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139951223650496 [Note] Plugin 'FEEDBACK' is disabled.
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139950150375168 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139950150375168 [Note] InnoDB: Buffer pool(s) load completed at 181215 10:50:53
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139951223650496 [Note] Server socket created on IP: '::'.
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139951223650496 [Note] Reading of all Master_info entries succeded
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139951223650496 [Note] Added new Master_info '' to hash table
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: 2018-12-15 10:50:53 139951223650496 [Note] /usr/sbin/mysqld: ready for connections.
    Dec 15 10:50:53 FlawlessStark-VM mysqld[16867]: Version: '10.2.19-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
    Dec 15 10:50:53 FlawlessStark-VM systemd[1]: Started MariaDB 10.2.19 database server.
  • i just upgraded to latest version and now it's saying:

    Cannot create database. Error message: Data supplied is not accepted.
  • I am checking your ticket.
  • I am able to create a database on your server just fine, you are using some prohibited characters on your password. Following are not allowed ; && | ...
  • Cannot create database. Error message: 0

    i get that, i have updated the ticket as well.
Sign In or Register to comment.
Support CyberPanel CyberPanel Discord

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!