08-11-2009
Because I didn't know I could install it that way. Thank you, that seems to have made that part painless at least. I suppose the same thing can also be done to install PHP.
By chance do you also know how I can find out which folder apache is set up as the public or the www folder for the domain?
Edit: Ok I'm still having trouble with setting up my sql group and users.
groupadd mysql
useradd -g mysql mysql
Last edited by Dark Severance; 08-11-2009 at 07:53 PM..
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how do i install php & mysql with apache on suse linux ???
apache was installed and configured when i installed linux.
all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/
so how do i install php and get it to work with apache and... (4 Replies)
Discussion started by: perleo
4 Replies
2. UNIX for Dummies Questions & Answers
What is the best way to run Apache2 and MySQL as daemons that run on startup? Can anyone give me some scenarios/examples. Thanks in advance! (3 Replies)
Discussion started by: ezekiel61
3 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a co-worker that uses javascript code to generate the last-modified date on a file. The problem is our server does not properly send this date so javascript can display it. I know that it is better to use server-side scripting to generate this but she has already put it on multiple... (1 Reply)
Discussion started by: robbieg
1 Replies
4. UNIX for Dummies Questions & Answers
Folks;
How can i setup ACL in Apache so i can give a group of users (defined by their emails (all users under *@red.com) access to a web page? (10 Replies)
Discussion started by: moe2266
10 Replies
5. Web Development
Hello there,
I installed Ajaxterm on my Ubuntu 9.04 machine, and it's running ok if I use : http://localhost:8022/ in my browser. The problem is that I wanted to be able to acces it from somewere else through the internet. I read some instruction and help sites related to this problem, like :... (2 Replies)
Discussion started by: spiriad
2 Replies
6. Red Hat
Hi,
This is my problem:
- I install and configure apache,php,mysql-server
- configure database on mysql and wp-config od Wordpress
- upload files wordpress in to public_html
and... i see results "blank page".
What is it? Where is problem?
(PS. I install and configure wordpress few... (1 Reply)
Discussion started by: gripek
1 Replies
7. Red Hat
I want to install Apache (version 2.2.X), php (version 5.3.X),mysql (version 5.5.X) on RHEL 5.5. Guide re. site address for download all rpm.
X = latest version.
Thanks in advance. (1 Reply)
Discussion started by: vasdaax
1 Replies
8. UNIX for Dummies Questions & Answers
I have recently setup a HTTP server using Apache.
This was my first install of Apache, so I am very new to it.
What I would now like to do is setup HTTPS for my server.
Unfortunately, the official Apache 2.2 manual doesn't cover setting up HTTPS, and using Google search engine I have found... (2 Replies)
Discussion started by: SSL
2 Replies
9. Ubuntu
on ubuntu lamp server how to install mysql and apache? any instructions? (1 Reply)
Discussion started by: srinathk
1 Replies
LEARN ABOUT PHP
pdo_mysql-dsn
PDO_MYSQL-DSN(3) 1 PDO_MYSQL-DSN(3)
PDO_MYSQL DSN - Connecting to MySQL databases
The PDO_MYSQL Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is mysql:.
o host - The hostname on which the database server resides.
o port - The port number where the database server is listening.
o dbname - The name of the database.
o unix_socket - The MySQL Unix socket (shouldn't be used with host or port).
o charset - The character set. See the character set concepts documentation for more information. Prior to PHP 5.3.6, this element
was silently ignored. The same behaviour can be partly replicated with the PDO::MYSQL_ATTR_INIT_COMMAND driver option, as the fol-
lowing example shows.
Warning
The method in the below example can only be used with character sets that share the same lower 7 bit representation as
ASCII, such as ISO-8859-1 and UTF-8. Users using character sets that have different representations (such as UTF-16 or Big5)
must use the charset option provided in PHP 5.3.6 and later versions.
Example #1
Setting the connection character set to UTF-8 prior to PHP 5.3.6
<?php
$dsn = 'mysql:host=localhost;dbname=testdb';
$username = 'username';
$password = 'password';
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);
$dbh = new PDO($dsn, $username, $password, $options);
?>
+--------+-----------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-----------------------------------------------+
| 5.3.6 | |
| | |
| | Prior to version 5.3.6, charset was ignored. |
| | |
+--------+-----------------------------------------------+
Example #2
PDO_MYSQL DSN examples
The following example shows a PDO_MYSQL DSN for connecting to MySQL databases:
mysql:host=localhost;dbname=testdb
mysql:host=localhost;port=3307;dbname=testdb
mysql:unix_socket=/tmp/mysql.sock;dbname=testdb
Note
Unix only:
When the host name is set to "localhost", then the connection to the server is made thru a domain socket. If PDO_MYSQL is compiled
against libmysqlclient then the location of the socket file is at libmysqlclient's compiled in location. If PDO_MYSQL is compiled
against mysqlnd a default socket can be set thru the pdo_mysql.default_socket setting.
PHP Documentation Group PDO_MYSQL-DSN(3)