Portal Home > Knowledgebase > Articles Database > Can't create database from every account
Can't create database from every account
| Posted by dungiis, 08-20-2007, 02:49 AM |
| Hi everyone !
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 .
May be the reasons were caused by Mysql .There are some error when i restart mysql . Some informations about this error
Sorry for my english D:
Thanks for your help.
Last edited by dungiis; 08-20-2007 at 02:54 AM.
|
| Posted by dungiis, 08-20-2007, 09:52 AM |
| I need your helps
|
| Posted by PH-Kev, 08-20-2007, 10:00 AM |
| Culd you try creating database again and seeing if same error occurs?
If it occurs can you check server status if cpanel allows.
And then if mysql shows red or if you cant see that option can you post back?
|
| Posted by david510, 08-20-2007, 10:12 AM |
| You must login as root to server ssh and restart mysql. After that try creating a database from the cpanel mysql area.
|
| Posted by YYamagishi, 08-20-2007, 10:46 AM |
| He has WHM/cPanel installed so I believe WHM/cPanel would do that automatically.
Check your mysqld logs.
Something is wrong with configuration or interrupting from starting
|
| Posted by dungiis, 08-20-2007, 10:47 AM |
| Some problems
|
| Posted by YYamagishi, 08-20-2007, 10:54 AM |
| I thought it was "service mysqld restart"
Maybe it's not for cPanel servers.....?
Anyways, in my.cnf check if you have basedir/datadir set.
If so, comment that out and see if it works or not
|
| Posted by dungiis, 08-20-2007, 11:16 AM |
| Checked mysql by command "service mysqld restart" but error
How to enable mysqld ?
|
| Posted by david510, 08-20-2007, 11:53 AM |
| He has provided the message he gets when he tries restarting mysql from WHM.
Its not mysqld. Mysql startup script comes in cpanel as service /etc/rc.d/init.d/mysql.
Check your mysql error log file. Normally it would be present at /var/lib/mysql/serverhostname.err
Run this command after restarting the mysql from shell.
tail -30 /var/lib/mysql/serverhostname.err
|
| Posted by YYamagishi, 08-21-2007, 03:44 AM |
| Well he has tried doing that from SSH:
And I clearly stated the possible fix for this issue.
|
| Posted by david510, 08-21-2007, 04:23 AM |
| Yudai Yamagishi,
Please read the thread carefully
In his first post he has given the error from WHM. So I said to restart from SSH. After that only he pasted the error in SSH. Yes, you have given a solution to fix the error.
|
| Posted by YYamagishi, 08-21-2007, 09:27 AM |
| Well sorry if I sounded rude.
I saw OP getting confused then you posted what to do after I gave solution to the problem so.
I would want to know if this problem has been fixed with my way, if not, you need to give me the output of what David told you to do.
(Got lazy to type )
|
| Posted by gate2vn, 08-21-2007, 12:16 PM |
| what's your mysql version? and the content of my.cnf file
|
| Posted by dungiis, 08-21-2007, 10:51 PM |
| Hi Gate2vn!
Nice to meet you . I am thinking of you for this trouble
This is some content of my.cnf
Thank for your help
|
| Posted by gate2vn, 08-21-2007, 10:56 PM |
| Try to comment out the line "basedir=/var/lib" and restart mysql service again.
|
| Posted by dungiis, 08-21-2007, 11:05 PM |
| I could not restart mysql
Can you show me your phone , YM or Email ?
( em gui root anh giup em nhe)
Last edited by dungiis; 08-21-2007 at 11:15 PM.
|
| Posted by gate2vn, 08-21-2007, 11:08 PM |
| ok, pm me your root login, then I can take a look
|
| Posted by dungiis, 08-21-2007, 11:18 PM |
| Okay ! PM you Done !
Thank Mr.Hung
|
| Posted by gate2vn, 08-21-2007, 11:25 PM |
| You havent commented out the line as I suggested. I just logged in ssh, edited the my.cnf file, then mysql service can start without trouble
|
| Posted by dungiis, 08-21-2007, 11:35 PM |
| Thank to Gate2vn . It's work fine
I still trouble with create database . I sent pm you . Hoping you help me once again
Last edited by dungiis; 08-21-2007 at 11:48 PM.
|
| Posted by dungiis, 08-23-2007, 02:55 AM |
| i don't understand what comment out line is .
content of my file my.cnf
[QUOTE]datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=50
table_cache=1000
thread_cache_size=40
thread_stack=100K
wait_timeout=10
join_buffer=2M
myisam_sort_buffer_size=6M
query_cache_size=6M
read_rnd_buffer_size=2M
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
...
UOTE]
what can i do to comment out the line "basedir="/var/lib" ?
|
| Posted by david510, 08-23-2007, 03:22 AM |
| Add a hash # to the beginning of the line as follows and restart mysql
#basedir=/var/lib
|
Add to Favourites 
Print this Article
Also Read
Jonesolutions (Views: 784)