CyberHosting

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.
  • You need to update password of PHPMyAdmin and map that password with CyberPanel backend to work properly, please check the screenshot how to fix this,

    https://nextgenai.cloud/how-to-change-cyberpanel-admin-and-root-password-safely/
Sign In or Register to comment.
CyberPanel Discord

Howdy, Stranger!

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