I have cpanel on my server but my license have some problem and I cannot login to cpanel or WHM , I have root access.
I need to create a Database immediately as same as cpanel create that.
how can I create a database with user and user privileges (same as when I create in cpanel)?
I am running a small VPS plan. I created one share account and login to cpanel but get some errors.
Can not create database from that cpanel .I don't know what i should do?
I have a VPS plan of Spry .I just ordered this plan . There are some problems in my WHM .My VPS is running by WHM .
I created one small account ( Shared hosting ) with user and pass but i can not create database name and user or pass database from this account .
I also access into phpmyadmin but i can not .
Quote:
phpMyAdmin - error
#2013 - Lost connection to MySQL server during query
May be the reasons were caused by Mysql .There are some error when i restart mysql . Some informations about this error
Quote:
Attempting to restart mysql [url] Waiting for mysql to restart.... . . . . . . . . . . finished.
mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
I hosted with windows hosting plan. From my control panel, I can only able to create password for database. Database name is assigned as ftp user name.
I don't know how to create tables inside that database. I can create tables using many tools in my desktop environment. But how can I create table in a database residing at server?
Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'
View 1 Replies View RelatedWarning: session_start() [function.session-start]: SQLite: failed to open/create session database `/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb' - malformed database schema - unable to open a temporary database file for storing temporary tables in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86
Fatal error: session_start() [<a href='function.session-start'>function.session-start</a>]: Failed to initialize storage module: sqlite (path: /var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86
I get that error in cPanel when I click to go to phpmyadmin.
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
Customer has requested the following:
"Create a zend id for your machine." This is apparently for them to create a product key for their software and have to bind to it?!
I have never heard of this and have been unable to locate any information on it.
This is a Centos box with php 5.2.5 installed:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies
how to go about this or even what this is?
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.