problems installing mysql

I'm running openSUSE 11.0 on Lenovo 3000 N100. I've tried several ways
to install mysql without success. There seem to be different problems
each time I try something different but the bottom line is I can't seem
to get it to work.

I first spent a lot of time trying to get the QuickStart Install from
the CD-ROM in _Sams Teach Yourself PHP, MySQL and Apache_ to work. It
had numerous problems but I eventually got all the permissions set to
777 and all the files owned by root. Then following the instructions in
the book I needed to run the command
scripts/mysql_install_db  --user=mysql
That command won't hunt. So I tried adding the ".sh" at the end, since
the relevant file seems to be scripts/mysql_install_db.sh. At that
point, I got this reply,
linux-pczd:/usr/local # cd mysql-5.0.51a
linux-pczd:/usr/local/mysql-5.0.51a # scripts/mysql_install_db.sh
-user=mysql
FATAL ERROR: Could not find @bindir@/my_print_defaults

If you are using a binary release, you must run this script from
within the directory the archive extracted into.  If you compiled
MySQL yourself you must run 'make install' first.


Anyway, I gave up on this approach and tried installing using Yast. The
install seemed to go fine, but now I can't get it to start--it seems to
start, to do something, and then quit.
linux-pczd:~ # mysqld_safe --user=mysql &
[1] 13739
linux-pczd:~ # nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/linux-pczd.site.pid
090510 15:09:00  mysqld ended


Can anyone help?

Thanks.


-- 
SuseNeo
------------------------------------------------------------------------



0
SuseNeo
5/10/2009 7:16:01 PM
opensuse.org.help.applications 21533 articles. 1 followers. Follow

5 Replies
790 Views

Similar Articles

[PageSpeed] 10

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

MySQL should be about the easiest thing to get going; you're just working
too hard.  ;-)

So with a new install (or after cleaning out everything else you've done)
you should be able to add the 'mysql' package via Yast and then set it to
start on bootup:

sudo zypper in mysql #install
sudo /sbin/chkconfig mysql on

Once done if MySQL isn't already running you can either reboot to start it
(lazy, but proves it will work on the next reboot) or start it manually:

sudo /etc/init.d/mysql status #see if it's running
sudo /etc/init.d/mysql start #start it up

To verify it is working:

netstat -anp | grep :3306

and you should see a line stating it is listening like the following:

tcp   0  0 0.0.0.0:3306  0.0.0.0:*      LISTEN      3647/mysqld-safe

Good luck.





SuseNeo wrote:
> I'm running openSUSE 11.0 on Lenovo 3000 N100. I've tried several ways
> to install mysql without success. There seem to be different problems
> each time I try something different but the bottom line is I can't seem
> to get it to work.
> 
> I first spent a lot of time trying to get the QuickStart Install from
> the CD-ROM in _Sams Teach Yourself PHP, MySQL and Apache_ to work. It
> had numerous problems but I eventually got all the permissions set to
> 777 and all the files owned by root. Then following the instructions in
> the book I needed to run the command
> scripts/mysql_install_db  --user=mysql
> That command won't hunt. So I tried adding the ".sh" at the end, since
> the relevant file seems to be scripts/mysql_install_db.sh. At that
> point, I got this reply,
> linux-pczd:/usr/local # cd mysql-5.0.51a
> linux-pczd:/usr/local/mysql-5.0.51a # scripts/mysql_install_db.sh
> -user=mysql
> FATAL ERROR: Could not find @bindir@/my_print_defaults
> 
> If you are using a binary release, you must run this script from
> within the directory the archive extracted into.  If you compiled
> MySQL yourself you must run 'make install' first.
> 
> 
> Anyway, I gave up on this approach and tried installing using Yast. The
> install seemed to go fine, but now I can't get it to start--it seems to
> start, to do something, and then quit.
> linux-pczd:~ # mysqld_safe --user=mysql &
> [1] 13739
> linux-pczd:~ # nohup: ignoring input and redirecting stderr to stdout
> Starting mysqld daemon with databases from /var/lib/mysql
> STOPPING server from pid file /var/lib/mysql/linux-pczd.site.pid
> 090510 15:09:00  mysqld ended
> 
> 
> Can anyone help?
> 
> Thanks.
> 
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQIcBAEBAgAGBQJKBymkAAoJEF+XTK08PnB5VhEQAMGibJdHyvPDhUF6VFs+QAwX
eOos3xwxhqdz1wGHUqG2+LyOKOsxVstjPLQs+2SDxpB0t6p6WmyszKYFluOFdbcm
JLc9rhXlRLhY9v0ZQ1x+KJcX1LJLCsGpr/C6kBXk8aGXw0M9ey8CKVQyhKXQZTcu
vPAHGjKuaVqeX/x2vzh2nFII8N5Q8e7JGAYmyC5xELZf1oMw2dKCH5ClTrM1O8WU
XvIdGSydEchxGkphdWspBhEXQVYNVqv3plPoDn+AQL6EFDvJ02oQtgL/OlrxL9o3
PauM4fqNCgxe3Z6xEP7ie7PAwqZjMeKl0/7u/GT7h2Uoq5WC9hgGwd82DRPtC0oQ
sSHinOlTIOOWscwLewrRblJUkjYtgF4lzFIPa8TwblOWxGKukBw/aSu+ZOoDSCzp
7+4o1Fn0kqEpa0glcyqwy/fOF4mx7HtnHDwEsWw+1LtFw9jR5iBcgLSNgw6jdCb2
MJeh5atIoIP1w4nPaPYuN6Og7qPA3wEt1VCKucH4dqOCTXNHpUMCWncKG6rgGTCs
4qMPDWFn84ff3c5PeFV3nZQAEY6BunZd2xFNrh3Hz0x2/uHa3ZezKFCIQaQlQxeN
tQpveEeWqeWISYHBNiNHHXBSetMRbD2Wl8HRCkTEWlQwf6EoB6pqPlN/45xJR3SS
ohB9m1oZvQ9edvjWci/M
=Efl/
-----END PGP SIGNATURE-----
0
ab
5/10/2009 7:23:16 PM
Thanks. Sounds like it should be easy, but still some questions.

ab wrote:
> So with a new install (or after cleaning out everything else you've
> done)
> you should be able to add the 'mysql' package via Yast and then set it
> to
> start on bootup:
> 
> sudo zypper in mysql #install
> sudo /sbin/chkconfig mysql on

1. "after cleaning out ...." 
a.  I used Yast to delete everything that a mysql search there
shows as installed--except the openoffice reference.
b.  Then ran > find / -xdev -name "mysql" =>

"/usr/lib/mysql" This seems empty. Can I leave it?
"/etc/apparmor.d/abstractions/mysql": Do I need to make changes here?
"/etc/sysconfig/mysql": Should I delete this file?
"/var/lib/mysql": I deleted this directory.

Is there anywhere else that I need to worry about before
re-installing?

2.  Do I use zypper as well as Yast? I thought that Yast did the
install. (What is the # in "#install" for? I'm not familiar with that.)

3. I had installed the following from Yast. Do I need anything else?
The PHP and PHPadmin modules if I want to do LAMP?
libmysqlclient15
libmysqlclient_r15
mysql
mysql-administrator
mysel-client
mysql-gui-tools

Thanks again.


-- 
SuseNeo
------------------------------------------------------------------------
SuseNeo's Profile: http://forums.opensuse.org/member.php?userid=20914
View this thread: http://forums.opensuse.org/showthread.php?t=414257

0
SuseNeo
5/10/2009 10:56:01 PM
From where you are now I'm not sure this will work, but on every fresh
install I do I install mysql, apache2 and php5 using Yast > Software >
Manage Software

Ten in Yast > System > Runlevel Editor 

Enable apache2 and mysql

Save.

Runs every time since 9.1.

I work with my php and html files in /home/logged in users/public_html

Works every time :)


-- 
Ski_K2
------------------------------------------------------------------------
Ski_K2's Profile: http://forums.opensuse.org/member.php?userid=6818
View this thread: http://forums.opensuse.org/showthread.php?t=414257

0
Ski
5/10/2009 11:26:01 PM
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

'zypper' is just another way and would not require you to do anything
except enter the command and enjoy the install.

A '#' is a comment; I was commenting the commands inline.

Good luck.





SuseNeo wrote:
> Thanks. Sounds like it should be easy, but still some questions.
> 
> ab wrote:
>> So with a new install (or after cleaning out everything else you've
>> done)
>> you should be able to add the 'mysql' package via Yast and then set it
>> to
>> start on bootup:
>>
>> sudo zypper in mysql #install
>> sudo /sbin/chkconfig mysql on
> 
> 1. "after cleaning out ...." 
> a.  I used Yast to delete everything that a mysql search there
> shows as installed--except the openoffice reference.
> b.  Then ran > find / -xdev -name "mysql" =>
> 
> "/usr/lib/mysql" This seems empty. Can I leave it?
> "/etc/apparmor.d/abstractions/mysql": Do I need to make changes here?
> "/etc/sysconfig/mysql": Should I delete this file?
> "/var/lib/mysql": I deleted this directory.
> 
> Is there anywhere else that I need to worry about before
> re-installing?
> 
> 2.  Do I use zypper as well as Yast? I thought that Yast did the
> install. (What is the # in "#install" for? I'm not familiar with that.)
> 
> 3. I had installed the following from Yast. Do I need anything else?
> The PHP and PHPadmin modules if I want to do LAMP?
> libmysqlclient15
> libmysqlclient_r15
> mysql
> mysql-administrator
> mysel-client
> mysql-gui-tools
> 
> Thanks again.
> 
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQIcBAEBAgAGBQJKB4oBAAoJEF+XTK08PnB5Yl0P/Rc11NVI76/PUhant9HtcX49
6EvwlIROIuN4WM8hhzr+MZUdXHZ7KPqVPXtsq9iNbHvDiER+bCjj306JmSwFKuKb
h1hNOcjmJdm44oDfAcD18F0N6AmA2X0YOKIVbi1TNjaAgADnGDijoJwlWZ5lVgr8
m9E/2giaji7dQiLwv1N4rZ6TZk/pQQtb8rUDAgXwj4z2LdO/AueUINndOmTd8OHO
hlzvDax6AbECL1ikUOmiw470k/gb43T559S8jsKlSk13rhvWImEXMhffwdqJyyXe
KTldLpzbcL5pbQ11qlGYxxVa5NxgsH03JQfz2N1oWxHfaumARLevcDeziw9zyukp
Bo3lXWO/GsDM7U2FjtuveEqn74KJGNFXTnTkduWjXGzej5k5g5IoaIv252M9sEpR
+J24OSH7gJ4in+dO3WJFIYlp0ysxNsVk5YW7GLYfQWr7PfWEUSYLrmrPsX0xlQtV
QnNrmFIAdsja6kFvNLw91LCdCzG5NCjzaUn+lpkXLiezYSQkIVXPpX5E8SWO/JU6
gwscJx1BGVjapTkclWqkQYwo1ncSmf2jbHfpVxBb2cHi1s5RkSlKQlLP6Te5tOqV
MCasF1wyVTT2s821vQbeF9WoHsQdQqdSushLn6OaSCImpwo4eDG9HILu1L7nuAIW
0zMJl3UjzxRFS4/U+tjX
=hnhE
-----END PGP SIGNATURE-----
0
ab
5/11/2009 2:14:25 AM
As ski_k2 described above, the best option is to install LAMP from
software management. And then edit Runlevel for each bootup to start
auto.
For phpmyadmin, i will give better option, is to use:
1- Mysql Administrator
2- Mysql Query Browser

You can install these from software management.
Best of luck.


-- 
'My Blog' (http://anl4u.blogspot.com)
'My Programming and Linux Blog' (http://anl4u-pl.blogspot.com)
LINUX IS LINUX.
WINDOWS IS WINDOWS BUT NOT LINUX.
------------------------------------------------------------------------
mmarif4u's Profile: http://forums.opensuse.org/member.php?userid=671
View this thread: http://forums.opensuse.org/showthread.php?t=414257

0
mmarif4u
5/11/2009 5:46:01 AM
Reply:

Similar Artilces:

Visual Studio 2005 Install Problem
Hi all, I have just rebuilt my XP machine and installed Visual Studio 2005. When trying to open previously created projects I get the following error message: The application for project <project> is not installed. Make sure the application for the project type () is installed. At this point I did some reading and googling and discovered that 'Web Application Projects' is not included in the base Visual Studio 2005 package. I installed Service Pack 1 (SP1) expecting this to fix the problem, however I still received the same error message when trying to open the application. ...

DBD::mysql install problem
Can someone tell me what to make of this output? It seems like there is something missing or wrong with libmysqlclient.a as I get this error: /usr/lib/mysql/libmysqlclient.a: could not read symbols: Bad value I also have other output that is telling me to do differnt things, but I have no idea what file is being used to try to change the settings. I only have one dependentcy to resolve for bugzilla, which is this one: Bugzilla requires that perl's DBD::mysql be installed. To install this module, you can do: /usr/bin/perl -MCPAN -e 'install "DBD::mysql"'...

Install problem: help? Failed two tests: t/akmisc.t failed test 44 and t/mysql.t failed test 23
Ok, I've searched and searched but all I can find here is other people from more than a year ago with the same problem but not follow-ups containing solutions, but I just *know* someone out there's got the same problem already figured out...i hope. Trying to install the DBD::mysql module and failing because of these tests: t/akmisc.t failed test 44 t/mysql.t failed test 23 I've looked but the code's above my head. Don't see this in a faq (although there is a faq about akmisc.t and msql which doesn't seem to apply). Did anyone else have this problem and ...

Problem with Interop.Excel when installing the application on an Application Server
Hello I am having the following problem, on my developer computer I can run a process that is launched by the web application that modifies an excel files and then saves it. Then after I create the installer and install it on the application server and run the process from there I get the following error: COM object with CLSID {00024500-0000-0000-C000-000000000046} is either not valid or not registered. I suppose that this is because the .dll is not registered on the server, but on the install project the Interop.Excel.dll is included, now I suspect that there might be two thi...

Help
Hi, 1) I have created a web deployment package (called LDD_WebSetup.msi and related exe file). I deployed the web application to the server (SPC7Server) and it worked fine. This was four weeks ago. 2) I made changes to some Crystal Reports and recompiled the web application on my development computer. Everything works fine. So I rebuilt the deployment package. 3) I copy the web deployment package created in 2) above to SPC7Server . I unstalled the web application that was installed in 1) above four weeks ago (thru Add/Remove Programs). Then I in...

Install Bugzilla on windows with postgresql problem... first install please help
Hi all, I'm doing my first install of bugzilla and run into this this problem. DBD::Pg is installed but checksetup.pl still complain about it. I'm really new to mozilla/perl/* stuff so I have no Idea how to solve this problem. I searched the web for an answer without success. Thansk for your help Best Regards /David ppm> rep add Bugzilla http://landfill.bugzilla.org/ppm Repositories: [1] ActiveState Package Repository [2] Bugzilla [3] Bugzilla [4] Bugzilla [5] Bugzilla ppm> install DBD::Pg ==================== Install 'DBD-PgPP' version 0.05 i...

Problem installing mysql
I'm running SUSE 10.3, and installed mysql from YaST. I started the mysql daemon at the command line as root. It created the mysql database and said to issue a couple of commands to set the root password. No magic there - same as it's done for the last hald dozen versions of SUSE that I've used. Except the 2nd line didn't work. I got the following error: koala:/var/lib # /usr/bin/mysqladmin -u root -h koala.mmc password ***** /usr/bin/mysqladmin: connect to server at 'koala.mmc' failed error: 'Host 'koala.mmc' is not allowed to connect to...

HELP!! INSTALL PROBLEM
Ok. what i did was preety stupid. i mounted the image file it extracted something. then i reboted the computer and a blue linux default default kernel is come up. i can't do anything and thank god i have a spare laptop.Please help!:'( PS: I tried the installation on desktop -- rishi_storm ------------------------------------------------------------------------ I don't understand your problem. Please explain in more detail what you did and what is happening now. For example I am making some huge guesses based on thephrases "mounted the image file&qu...

mysql installation problems
I've encountered the same problem. There appears to be a configuration problem with mysql 5.0.22 as builds/tests work fine with 5.0.20. The unresolved symbol __pure_virtual exists in the <mysql_install_dir>/lib/libmygcc.a file. You can do one of two things: 1) modify your <mysql_install_dir>/bin/mysql_config script and add "-lmygcc" to the end of the librarys to link. I added it to the end of this line in the script: libs=" $ldflags -L$pkglibdir -lmysqlclient -lz -lcrypt -lnsl -lm -lmygcc " Then go ahead and build DBD-mysql 2) Altern...

MySQL installation problem
--____XOPFNQSGYDUFSSESQYID____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Sat, 10 Aug 2007 08:55:37 -0400" SGk6DQpJIGhhdmUgdHJpZWQgdG8gaW5zdGFsbCBNWVNRTDUgZGF0YWJhc2Ugb24gYSBOZXR3YXJl IDY1IHNwNS4gSSBjcmVhdGVkIHRoZSBteS5jbmYgZmlsZSBhbmQgdGhlIGRhdGFiYXNlIHdvdWxk IG5vdCBjcmVhdGUgdGhlIGluaXRpYWwgZGF0YWJhc2UuIFdoZW4gdGhlIG15c3FsX2luc3RhbGxf ZGIgaXMgcnVuLCB0aGUgbWVzc2FnZSBpcyB0aGF0IHRoZSBpbml0aWFsIGRhdGFiYXNlIGhhcyBi ZWVuIGNyZWF0ZWQsIGJ1dCB0aGUgZm9sZGVyIGluIHdoY2loIHRoZSBkYXRhYmFzZSBzaG91bGQg cmVz...

Help!!!!The installing problem
&#26080;&#27861;&#20174;URL'iso:/?iso=suselinux.iso&url=hd:///?device=/dev/sda6&filesystem=auto' &#21019;&#24314;&#23433;&#35013;&#28304; Failed to mount /mounts/mp_1002 on /var/adm/mount/ap_ox00000001:mounting media failed(mount:special device /mounts/mp_1002 dose not exit) Please Hlep me!!!!!!!!!!!!! -- shizenghua ------------------------------------------------------------------------ shizenghua, Could you please provide a bit more detail, how far into the install do you get before this error shows? If this sh...

MySQL Install Problem
Hi there, I have a problem during the installation setup. I have a brand new MySQL installation running and can connect myself as root. Now I'm trying /usr/bin/perl install-module.pl DBD::mysql and this is the result: Checking for CPAN (v1.81) ok: found v1.96 Checking for YAML (any) ok: found v0.72 CPAN: Storable loaded ok (v2.15) Going to read '/root/.cpan/Metadata' Database was generated on Mon, 11 Apr 2011 11:27:21 GMT Installing DBD::mysql version 4.018... Running install for module 'DBD::mysql' Running make for C...

help!install problem!
I am installing a replication system on an WINDOWS NT 4.0,when i finish configuring my replication server and start to build it ,it pause for some reason I don't know.I had checked the log file ,it showed like below: Use, duplication, or disclosure by the United States Government is subject to restrictions as set forth in FAR subparagraphs 52.227-19 (a)-(d) for civilian agency contracts and DFARS 252.227-7013 (c)(1)(ii) for Department of Defense contracts. Sybase reserves all unpublished rights under the copyright laws of the United States. Sybase, Inc. 6475 Christie Ave...

Install problems
I have a tree with two clustered NW 6.5sp1 servers and one 5.1 server. Now I have to install another NW 6.5 server into this tree. I have the NW6.5sp1a installation media. When I try (in eDirectory install phase) to add this new server in the existing tree a try to browse the tree - server abends in one of java functions. When I set the tree name and context manually - an error message says this is not ORGANIZATIONAL UNIT or ORGANIZATION context. (But this is not true!!) Can you help me, please? Josef Becvar Do you happen to have a name conflict between the tree n...

Web resources about - problems installing mysql - opensuse.org.help.applications

Help:Installing Japanese character sets - Wikipedia, the free encyclopedia
This help page will help you install Japanese character sets so that your computer will display them properly on the internet in your web browser ...

Earn Free Facebook Credits For Installing Apps — Of Course, There’s A Catch
This looks pretty cool at first: Earn free Facebook Credits for installing applications on your iPhone or Android device. AppDog offers this ...

Installing solar panels - Flickr - Photo Sharing!
Solar panels are lifted into place.

Installing Afterglow AX.1 Wired XBOX 360 Controller on Lion/Mountain Lion 10.7.3+ - YouTube
I finally managed to install an Afterglow AX.1 (Wired XBOX Controller) and make it work on Lion 10.7.3 with TattiBogle 0.08. This tutorial works ...

Fatal unit fire: Builder Ray Finianos reduced height of building to avoid installing fire sprinklers ...
The builder of&nbsp;a south-west Sydney unit block where a young woman plunged to her death during a ferocious fire told a certifier to reduce ...

Ballarat man accused of installing spy cameras in ex-wife's house
A man accused of concealing surveillance cameras in skirting boards at his ex-wife's home also allegedly attached a GPS tracker to her car, a ...

Iran installing new nuclear equipment
Sky News is Australia's leader in 24-hour news. Iran has begun installing next-generation equipment at one of its main nuclear plants, a new ...

Rentasaur Installing 'Spyware' On Rental Laptops
An Australian business that rents out computers is installing software that in the US has been used to spy on users, including taking webcam ...

Gillard defends installing Slipper
BBC News Gillard defends installing Slipper Sydney Morning Herald Prime Minister Julia Gillard has defended her decision to install Peter ...

CSIRO says installing solar panels on roofs of businesses could take pressure off the electricity grid ...
Installing more solar panels on the roofs of businesses would help Australia's energy grid cope with increased demand.

Resources last updated: 1/9/2016 3:27:48 PM