I just downloaded the second beta and i'm stuck on MySQL part of the install:
---from file---
Import the files in the sql/ directory into MySQL using 'mysql -uusername -p < file.sql' in the following order:
------end------
when i do this it asks me my password and gives me this:
ERROR 1044 at line 1: Access denied for user: 'peanu220@localhost' to database '
phpwebhosting'
I don't know anything about MySQL and maybe i'm doing something wrong? Could you please help me? Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1) You need root access to the MySQL database in order to import sql/user.sql. If you don't have root access, it will not work. This is ok, because you do not need a separate user account for phpwebhosting (although it is recommened for better security). However..
2) You probably need root access to the MySQL database in order to add a new database. The database in this case is 'phpwebhosting', which would explain the error you got when importing sql/tables.sql. Some MySQL accounts have access to create new databases, some don't. It depends on what the adminstrator decided. To see if you have access, log into mysql normally and select the mysql database ('mysql -uusername -p mysql'), then "SELECT * from user where user = 'username'". The "Create_priv" column dictates whether you have creation access or not.
So if you have root MySQL access, use that username/password instead. If not, you'll have to ask your database adminstrator to either import the files (point him/her to the INSTALL file), or ask him/her to give you database creation privileges.
Let me know if you need more help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2000-11-08
If i don't do the '< file.sql' part i can still access mysql without being root. Are you totally sure I need root to do this?
Also is there any other aspects of this script that needs root, (which i don't have access to)? Could I be wasting my time try to use this?
Thanks for your help!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You're right, you can use MySQL without begin root. But the question is what databases can you access? Normally an administrator creates a database with the same name as your username, and you get full access to that database, but access to no other databases.
If you want to install PHPWebHosting inside of an existing database, you only have to change 4 lines. In sql/tables.sql, delete the first line, and change the 'use phpwebhosting;' line in sql/tables.sql and sql/values.sql to whatever name your database is.
Then change the $sql* values at the beginning of sql.inc.
That will setup the necessary changes for the install; just follow the rest of the instructions in the INSTALL file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2000-11-11
Awesome thanks for the help!
I got it running...but wierd stuff is going on that i can't understand ;-)
First thing is when I got the the front end of the script ever page has stuff like this:
-------
HTML_PAGE_BEGIN_BEFORE_TITLEUsers :: testHTML_PAGE_BEGIN_AFTER_TITLE
OR
HTML_TEXT_BLOCK_MAIN_PAGE
-------
what's this and is suppose to show up?
Second thing is i made an account called "test" and i logged in and everything was cool...then i tryed to figure out where the dir 'test' was on the server...no dir so i figured well maybe i have to upload something first. So i uploaded some file named 'faq.txt' and then looked around...nothing...
Where is the user dirs made? and why aren't they showing up anywhere??
again i'm using the 2nd beta of version 2.
again thanks for all this help! you're a life saver!
-------
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The HTML_PAGE_BEGIN_BEFORE_TITLE and the like are vaules taken from the settings database. You need to run 'php sql/values.php'. That will add the vaules to the database. If you don't happen to have the php binary installed, you should be able to run the script by accessing it from the web.
As for where the directories are installed, and what permissions you need, see the message in this forum from Oct. 30, which was a reply to Wedgemusic. That should answer all of your questions. (You'll probably have to chmod 777 the public_html directory unfortunately, because you do not have root access).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just downloaded the second beta and i'm stuck on MySQL part of the install:
---from file---
Import the files in the sql/ directory into MySQL using 'mysql -uusername -p < file.sql' in the following order:
------end------
when i do this it asks me my password and gives me this:
ERROR 1044 at line 1: Access denied for user: 'peanu220@localhost' to database '
phpwebhosting'
I don't know anything about MySQL and maybe i'm doing something wrong? Could you please help me? Thanks!
1) You need root access to the MySQL database in order to import sql/user.sql. If you don't have root access, it will not work. This is ok, because you do not need a separate user account for phpwebhosting (although it is recommened for better security). However..
2) You probably need root access to the MySQL database in order to add a new database. The database in this case is 'phpwebhosting', which would explain the error you got when importing sql/tables.sql. Some MySQL accounts have access to create new databases, some don't. It depends on what the adminstrator decided. To see if you have access, log into mysql normally and select the mysql database ('mysql -uusername -p mysql'), then "SELECT * from user where user = 'username'". The "Create_priv" column dictates whether you have creation access or not.
So if you have root MySQL access, use that username/password instead. If not, you'll have to ask your database adminstrator to either import the files (point him/her to the INSTALL file), or ask him/her to give you database creation privileges.
Let me know if you need more help.
If i don't do the '< file.sql' part i can still access mysql without being root. Are you totally sure I need root to do this?
Also is there any other aspects of this script that needs root, (which i don't have access to)? Could I be wasting my time try to use this?
Thanks for your help!
You're right, you can use MySQL without begin root. But the question is what databases can you access? Normally an administrator creates a database with the same name as your username, and you get full access to that database, but access to no other databases.
If you want to install PHPWebHosting inside of an existing database, you only have to change 4 lines. In sql/tables.sql, delete the first line, and change the 'use phpwebhosting;' line in sql/tables.sql and sql/values.sql to whatever name your database is.
Then change the $sql* values at the beginning of sql.inc.
That will setup the necessary changes for the install; just follow the rest of the instructions in the INSTALL file.
Awesome thanks for the help!
I got it running...but wierd stuff is going on that i can't understand ;-)
First thing is when I got the the front end of the script ever page has stuff like this:
-------
HTML_PAGE_BEGIN_BEFORE_TITLEUsers :: testHTML_PAGE_BEGIN_AFTER_TITLE
OR
HTML_TEXT_BLOCK_MAIN_PAGE
-------
what's this and is suppose to show up?
Second thing is i made an account called "test" and i logged in and everything was cool...then i tryed to figure out where the dir 'test' was on the server...no dir so i figured well maybe i have to upload something first. So i uploaded some file named 'faq.txt' and then looked around...nothing...
Where is the user dirs made? and why aren't they showing up anywhere??
again i'm using the 2nd beta of version 2.
again thanks for all this help! you're a life saver!
-------
The HTML_PAGE_BEGIN_BEFORE_TITLE and the like are vaules taken from the settings database. You need to run 'php sql/values.php'. That will add the vaules to the database. If you don't happen to have the php binary installed, you should be able to run the script by accessing it from the web.
As for where the directories are installed, and what permissions you need, see the message in this forum from Oct. 30, which was a reply to Wedgemusic. That should answer all of your questions. (You'll probably have to chmod 777 the public_html directory unfortunately, because you do not have root access).