Fwd: Re: [SLE] Similar mysql problem
Hi Patrick On Thursday 18 October 2001 23:20, you wrote:
1. Installed the mysql, mysql-bench, and mysql-shared through yast2 at the command line. 2. Edited my /etc/rc.config so that START_MYSQL="yes" 3. Ran SuSEconfig 4. rebooted
I'm not sure why you rebooted - this isn't necessary with Linux in most cases. Instead you could just have run rcmysql start. I don't think you need mysql-bench, which are benchmarks for testing speed etc. But I suspect you should install mysql-client ...
I've tried the process, suggested in a previous email, of rcmysql stop, mv /var/lib/mysql /mysqlold, rcmysql start, but that lists the same error failed: Starting mysqld daemon with databases from /var/lib/mysql
As root, delete /var/lib/mysql entirely. As root, run: rcmysql start Report the results. Best wishes Kevin -- 10:08am up 9 days, 1:54, 1 user, load average: 0.06, 0.02, 0.00
On Friday 19 October 2001 3:31 pm, Kevin Donnelly wrote:
On Thursday 18 October 2001 23:20, you wrote:
1. Installed the mysql, mysql-bench, and mysql-shared through yast2 at the command line. 2. Edited my /etc/rc.config so that START_MYSQL="yes" 3. Ran SuSEconfig 4. rebooted
I'm not sure why you rebooted - this isn't necessary with Linux in most cases. Instead you could just have run rcmysql start. I don't think you need mysql-bench, which are benchmarks for testing speed etc. But I suspect you should install mysql-client ...
I've tried the process, suggested in a previous email, of rcmysql stop, mv /var/lib/mysql /mysqlold, rcmysql start, but that lists the same error failed: Starting mysqld daemon with databases from /var/lib/mysql
As root, delete /var/lib/mysql entirely. As root, run: rcmysql start
I haven't caught any of this thread but thought my KJots entry on mySQL may be helpful. Essentially, it's the same for SuSE 7.1 and 7.2. PHP MySQL on suse 7.0 On Saturday 18 August 2001 12:07 pm, Julien Guillaume wrote:
Hello,I'm a new user of suse linux. I never work on a Linux platform before. I need to install the latest version of PHP and MySQL on suse 7.0. Does anybody have a moment to help me ? Make a simple explaination please !!!
I assume that you have a running SuSE 7.0 system, the CDs and/or access to
the SuSE ftp server. You will need to install the following packages:
apache
mod_php
mod_php-core
phpdoc (online php reference)
mysql
mysql-client
mysql-shared
I suggest that you download the latest RPMs from the SuSE ftp server
(ftp.suse.com or a mirror, e.g. ftp.mirror.ac.uk/sites/ftp.suse.com/). Once
you have downloaded these packages use either YaST1->Package
Management->Install Packages or rpm -ivh /path/to/files/package_name.rpm from
the console (analogous to MS-DOS Prompt window).
Once the packages are installed you will need to start apache and mysql from
console:
/etc/rc.d/apache start
/sbin/init.d/mysql start
N.B. These locations are not valid from 7.0 onwards since the Linux Standard
Base (LSB) is now used. See /sbin/init.d.README if you use later versions of
SuSE.
If you wish to run these as daemons you need to edit /etc/rc.config (always
run SuSEconfig after making the changes).
Set START_MYSQL in /etc/rc.config to "yes" and then run rcmysql start (from
root). This then states that
the root password must be set as follows:
/usr/bin/mysqladmin -u root -p password 'password'. You are prompted for the
current password, which is <NULL> initially.
This should do it for you. However, you may wish to customise Apache to
better suit your needs. If .php files are not recognised you need to edit
/etc/httpd.conf (now /etc/httpd/httpd.conf) and look for the line
"DirectoryIndex index.html" and append index.php.
Please remember that all these changes need to be done as root. However, it's
best to get into the habit of never logging in as root; login as a normal
user and then use the "su root" command from the console.
Finally, to test your configuration, create a file called phpinfo.php and
include the following:
<? phpinfo(); ?>
Save the file in /home/your_account_name/public_html. You can access this
file by typing:
http://localhost/~your_account_name/phpinfo.php using konqueror etc. Or, from
remote machine by substituting localhost with the machines IP address.
Mow used. See /sbin/init.d.README if you use later versions of
SuSE.
If you wish to run these as daemons you need to edit /etc/rc.config (always
run SuSEconfig after making the changes).
Set START_MYSQL in /etc/rc.config to "yes" and then run rcmysql start (from
root). This then states that
the root password must be set as follows:
/usr/bin/mysqladmin -u root -p password 'password'. You are prompted for the
current password, which is <NULL> initially.
This should do it for you. However, you may wish to customise Apache to
better suit your needs. If .php files are not recognised you need to edit
/etc/httpd.conf (now /etc/httpd/httpd.conf) and look for the line
"DirectoryIndex index.html" and append index.php.
Please remember that all these changes need to be done as root. However, it's
best to get into the habit of never logging in as root; login as a normal
user and then use the "su root" command from the console.
Finally, to test your configuration, create a file called phpinfo.php and
include the following:
<? phpinfo(); ?>
Save the file in /home/your_account_name/public_html. You can access this
file by typing:
http://localhost/~your_account_name/phpinfo.php using konqueror etc. Or, from
remote machine by substituting localhost with the machines IP address.
M
--
Martin Webster
participants (2)
-
Kevin Donnelly
-
Martin Webster