Urgent MySql question - GoFuckYourself.com

Damian_Maxcash · 08-26-2005, 07:00 AM

Im getting this when running a .mysql query

Quote:

ERROR 1006: Can't create database 'XPanel'. (errno: 13)
ERROR 1: Can't create/write to file './XPanel/users.frm' (Errcode: 2)
ERROR 1146: Table 'XPanel.users' doesn't exist
ERROR 1146: Table 'XPanel.users' doesn't exist
ERROR 1146: Table 'XPanel.users' doesn't exist
ERROR 1: Can't create/write to file './XPanel/named.frm' (Errcode: 2)
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

ERROR 1006: Can't create database 'XPanelPHPBB'. (errno: 13)
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 0 rows affected (0.01 sec)

Is this a permissions problem? - anyone got any idea?

Thanks!!

Femme Fa'tale · 08-26-2005, 07:04 AM

Yes it is... try checking your previlages....

Damian_Maxcash · 08-26-2005, 07:05 AM

Quote:

Originally Posted by Femme Fa'tale

Yes it is... try checking your previlages....

Thanks

Damian_Maxcash · 08-26-2005, 07:35 AM

I cant do anything with any MYSql db on my server

They are all reading and writing ok.... IE Scripts are working

But its saying I dont have any permissions to create new DBs etc

Anyone know how to fix this?

HELP!!

grumpy · 08-26-2005, 07:59 AM

let your provider change your privileges

Doc911 · 08-26-2005, 08:23 AM

the mysql user doesn't have the right privilages

Damian_Maxcash · 08-26-2005, 09:16 AM

Quote:

Originally Posted by Doc911

the mysql user doesn't have the right privilages

Yep.... somethings very fucked up because Im using the MySql root and pass

Doc911 · 08-26-2005, 09:22 AM

you're installing phpBB2? don't you have to create a blank DB for that before doing the install script? maybe thats why you are having the problem

Damian_Maxcash · 08-26-2005, 09:24 AM

Quote:

Originally Posted by Doc911

you're installing phpBB2? don't you have to create a blank DB for teat before doing the install script? maybe thats why you are having the problem

Its actually XPanel - it has a table for hosted phpbb

PussyTeenies · 08-26-2005, 09:35 AM

use webmin/cpanel/phpmyadmin.. just so you can give yourself the correct privileges ie write/read access etc etc

Doc911 · 08-26-2005, 09:46 AM

does your host limit the number of mysql databases you can have?

Damian_Maxcash · 08-26-2005, 10:14 AM

Quote:

Originally Posted by Doc911

does your host limit the number of mysql databases you can have?

No... Its a dedicted server - thats why its odd

Im using the root account

08-26-2005, 07:59 AM	#5
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	let your provider change your privileges __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

08-26-2005, 08:23 AM	#6
Doc911 Confirmed User Join Date: Feb 2004 Location: If i was up your ass you'd know Posts: 3,695	the mysql user doesn't have the right privilages __________________ For PHP/MySQL scripts ICQ 161480555 or email [email protected]

08-26-2005, 09:22 AM	#8
Doc911 Confirmed User Join Date: Feb 2004 Location: If i was up your ass you'd know Posts: 3,695	you're installing phpBB2? don't you have to create a blank DB for that before doing the install script? maybe thats why you are having the problem __________________ For PHP/MySQL scripts ICQ 161480555 or email [email protected]

08-26-2005, 09:35 AM	#10
PussyTeenies Confirmed User Join Date: Feb 2005 Location: Haarlem and Amsterdam, capital of the porn world ;-) Posts: 6,496	use webmin/cpanel/phpmyadmin.. just so you can give yourself the correct privileges ie write/read access etc etc __________________ Need adult hosting? Contact us! WARM Hosting Need an IT solution? or someone to check your site and security? Nossie - IT Professional

08-26-2005, 09:46 AM	#11
Doc911 Confirmed User Join Date: Feb 2004 Location: If i was up your ass you'd know Posts: 3,695	does your host limit the number of mysql databases you can have? __________________ For PHP/MySQL scripts ICQ 161480555 or email [email protected]

08-26-2005, 07:04 AM	#2
Femme Fa'tale Confirmed User Join Date: Nov 2004 Location: U.S. Posts: 541	Yes it is... try checking your previlages....

08-26-2005, 07:35 AM	#4
Damian_Maxcash So Fucking Banned Join Date: Oct 2002 Location: MaxCash.com Posts: 12,745	I cant do anything with any MYSql db on my server They are all reading and writing ok.... IE Scripts are working But its saying I dont have any permissions to create new DBs etc Anyone know how to fix this? HELP!!