9AF
-
Posts
8 -
Joined
-
Last visited
Never
9AF's Achievements
Newbie (1/5)
0
Reputation
-
I think I\'ve managed to resolve the issue. I went into the edit option for the account I created in Control Center. Selected the databases tag and made sure the database created was only attributed to the account. For the root account I also made sure I removed the database from the list of used databases. Thanks for the response[/b]
-
Hi all, I am trying to make mysql more secure by not having databases created and listed under root. I have created my own account with all the necessary privileges. However, if I create a database whilst logged in with my account, later on when I exit and re-enter the Control Centre the database I created is listed under root. Is there an option in the setup that causes this to happen or am I just not doing something correctly? I am using MySQL 4.0.16 and Mysql Control Centre 0.93. Thanks RB
-
I\'ve managed to resolve the problem, I think. libphp4.so was not installed in the modules directory. I made a copy from the php source distro and put it into the modules folder. I added the line LoadModule php4_module modules/libphp4.so, and it started to work. Though I am somewhat confused as I thought AddModule\'s are supposed to be core components of Apache Server. Does libphp4.so replace the need for AddModules? Thanks for your response LAMP. I am definitely going to try replicate your httpd.conf structure to see what happens. RB
-
I have installed apache 2.0.47 about three times on Linux Mandrake 9.1 The installation is ok, but every time I access the httpd.conf file there are no AddModules listed as well as there being no mention of ClearModuleList. I have followed the install instructions from php.net, see PHP and Apache 2 on Linux at http://www.php.net/manual/en/install.apache2.php, and yet they never appear. I am unable to compile any php code without AddModule mod_php4.c which I cant seem to add successfully. Does anybody have suggestions? Much obliged RB[/b]
-
Hi Hi Kevin You will need to create another table called Product Colour for example with the following structure: id - (autonumber) - primary key colour - (varchar) productid - foreign key You will need to have a one-to-many relationship between the tables \'Product\' (one side) and \'Product Colour\' (many side) with productid as the foreign key in table \'Product Colour\'. In this new table you can then associate a colour to each specific product. This should resolve your prob. Hope this is ok. RB
-
Thanks for the responses. I have managed to solve the problem by using user \'root\' and a password set to user \'root\'. The PHP code runs fine now. Though I did set a user and a password using mysqladmin for some reason nothing happened (defnitely something to do with permissions). In the documentation it does state somewhere to use user \'root\' when first using a new installation of MySQL as it has all the permissions set already. Thanks again for your help its much appreciated. 9AF
-
I have recently started to work on MySQL, PHP and apache and I\'m still finding my way round. Having installed apache 2.0.44 (successfully), with MySQL 4.0 and PHP 4.3.2 I found this script which is suppose to help show that all works with PHP/MySQL. The code is: <html> <head><title></title></head> <body> <?php $host=\"localhost\"; $user=\"pj\"; $password=\"buzz\"; mysql_connect($host, $user, $password); $db_table = mysql_list_dbs(); for ($i = 0; $i < mysql_num_rows($db_table); $i++) { echo(mysql_tablename($db_table, $i)); echo(\" \"); } ?> </body> </html> However, I keep on getting this error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user: \'rb@127.0.0.1\' (Using password: YES) in C:Program FilesApache GroupApache2htdocstest.php on line 8 mysql test Is this test that I\'m trying to do valid? If so what have I done wrong. Any feedback would be much appreciated. Regards 9AF
-
I have recently been looking at particular servers to use to help me develop a site using PHP. Obviously apache comes up a lot. However, I am using Zone Alarm 3.1.395 as my firewall and i have read on apache.org that (a) Zone Alarm is not supported and (B) many people using this combo are having problems. So my question is: Has anybody here used zone alarm and apache successfully? If not, do you have any recommendations as to which servers to go for in relation to the firewall that I\'m using? Or would I be better off using another firewall package? If I\'m barking up the wrong tree please tell me. I would appreciate any advice. Thanks in Advance 9AF