Thread: my sql
Results 1 to 15 of 15
05-06-2003, 03:56 PM #1
ok i read all install guides and everything as most of you know by know all i need is a little push and it sends me on my way so after reading the install guides and everything else it says stop at my sql and i don't know what that is or how to create it i know for a fact my host has that but i need some advice on how to create a my sql database so i can get my fourm alive an kickin thanks!!
05-06-2003, 04:06 PM #2
In theory, the install scripts do most of the work for you.
However, you will need -
- Database Server name (prob localhost)
- Database name (your host should have/will tell you this)
- Database user name (same as above)
- Database Password (same as above)
Knowing for sure that your host supplies these tells me you probably have already been sent most if not all of this info. If not, contact your host. Good luck.
05-06-2003, 04:24 PM #3
05-06-2003, 09:23 PM #4
this is what they said
>> You can create new database in your Plesk control panel. The same is true for username and password. Use localhost as your database server. thats what they said i look throught it and i still don't know what there talking about any advice
05-07-2003, 01:33 AM #5
Log into your control panel. Its in there somewhere.
05-07-2003, 03:03 PM #6
allright i found it but what do i name it
05-07-2003, 03:35 PM #7
What do you fancy
name it in my honour , call it 'git'
You can name it whatever you wish. Pay attention to what it says after, sometimes they prefix the db name. For instance, on my host, if I make a database called 'badger' with username of 'stoat', the db ends up called 'somepeop_badger' and the user name is 'firstname.lastname@example.org' so pay attention and you will be fine.
05-08-2003, 02:06 PM #8
ok this is getting really frustrating i get this when i do everything the installiation guide says i just don't under stand what i am doin wrong Warning: Host 'host1.esphinx1.net' is not allowed to connect to this MySQL server in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 48
Warning: MySQL Connection Failed: Host 'host1.esphinx1.net' is not allowed to connect to this MySQL server in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 48
Warning: Supplied argument is not a valid MySQL-Link resource in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 330
Warning: Supplied argument is not a valid MySQL-Link resource in /home/httpd/vhosts/paniclegs.com/httpdocs/phpBB2/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
???? anyone know because i sure don't i would be willin to pay to get some one to set this fourm up
05-08-2003, 04:20 PM #9
Hmm, are you trying to connect to a remote mysql server?
05-08-2003, 06:02 PM #10
no i am using the install phpbb i am following instructions
05-08-2003, 07:55 PM #11
05-08-2003, 08:55 PM #12
no but that fixed it thanks so much to all of you guys who help me out thanks thanks thanks
05-08-2003, 09:37 PM #13
Glad you have it working. Not to bust your b*lls, but, Quietdean's first post stated to try localhost as well as the docs with the phpbb stated localhost as the probable server. Could have saved yourself some grief.
05-08-2003, 09:56 PM #14
haha yeah i didn't really know what localhost meant i am a little newbish i am all good with html and flash but php kills me
10-09-2003, 02:23 PM #15
Have you run the Setup program ? Aparently, if you go to http://yourdomain.com/admin you'll have an admin control panel, and there should be a Setup program.
It looks like you're trying to use a database server that is not on your server.
If you have run through the setup, you may need to modify the MySQL server permissions - this requires that you can access the MySQL server somehow. As long as you can get a SQL prompt (if you are not the SQL database admin, you will need them to do this) and give yourself permission :
insert into users('yourserver.com','username',PASSWORD('password'),'Y','Y','Y','Y','Y','Y','Y','N','N','N','N','N','N');
That should give you access.
Last edited by HTML; 10-31-2003 at 05:08 PM.