mysql on sol10 x86


 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications mysql on sol10 x86
# 1  
Old 08-27-2008
mysql on sol10 x86

i installed the x86 version (32-bit) of mysql community db. looks like the initial install of the pkg was good. however, i've got a few questions here.

after the install, i run `/usr/local/mysql/scripts/mysql_install_db --user=mysql` to generate the db's and tables. it looks like a clean install of these with no error outputs. next i attempted to start the db. however, when i issue `mysqld_safe --user=mysql &` the mysqld ends. error logs just say "mysqld ends". interestingly, i can start the mysql service via `/usr/local/mysql/support-files/mysql.server start`. this says the system comes up successfully.

any clues as to why one start method works over the other?

when i ran the mysql_install_db script, again, it says it completes succesfully. however, i cannot log in to the db with any user (root). i ran `mysqld_safe --skip-grant-tables &` and saw the schema db, mysql and test dbs. however, no tables are avaiable within any of the dbs. any thoughts??
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

FTPD ls problem on Sol10

Hey guys, i'm pretty sure this is simple enough so i'll go quick. I must be missing something but can't pinpoint it. NOTE: Yes, i should be using proftpd but the architect team is a pain in the butt and it is not possible right now. Sol10 FTP server (zoned) MS vista ftp client. Login... (1 Reply)
Discussion started by: maverick72
1 Replies

2. Solaris

Sol10 - OpenLDAP Auth

Hi, im new to Solaris (10) and need some help please. Situation: Actually is there a Linux (SLES11) OpenLDAP-Server and authentification of Linux-Maschines works pretty sweet. Now i want to put the SOL10 (Sparc) boxes in.... Problem: User Authentification via OpenLDAP on Sol10 doesn´t work... (3 Replies)
Discussion started by: Panzerkampfwagn
3 Replies

3. Solaris

Help with Sol10 boot error

I just ran the latest ( 9-27-11) solaris patch set on my sparc testbed ( ultra80 ). Brought down to single user mode and ran patches as I always have. When I rebooted it after completion it came up with the following error on boot. "Fast Access Data MMU Miss". I can boot to a cdrom in... (5 Replies)
Discussion started by: bow tie klr
5 Replies

4. Solaris

machine to learn Sol10

Hi What kind of Sun machine, you recommend to buy in order to learn Solaris 10 administration ? I need machine where I can train the following sol10 features : - zfs - solstice suite (RAID 0+1, RAID 5, RAID 1 + 0 ) - containers Please advice sth for reasonable price. thx for help. (8 Replies)
Discussion started by: presul
8 Replies

5. Solaris

32 bit MySQL on x86 64 bit?

Hello all. I am going to build an x86 Solaris box. Sun only offers it in a 64 bit flavor. I want to put MySQL on this box. MySQL only comes in a 32 bit version for x86 Solaris. Can I run 32 bit apps on a 64 bit x86 Solaris machine? Thanks! (4 Replies)
Discussion started by: RobertSubnet
4 Replies

6. Solaris

Sol10 on primepower 850

I've got a console that seems to be hung. all other services (ip, etc) work perfectly. in fact, its still in production... we just don't have console access. so i there are two consoles on this guy.. scfc0 and scfc1. using iompadm from fujitsu, this is what i got: # ./iompadm -c FJSVscf3 info... (1 Reply)
Discussion started by: pupp
1 Replies

7. Solaris

sol10 on x86 -> network issue

i've decided to try out an x86 system with sol10. however, i can't get my 3com 3C905TX-B to work. i checked the hcl and it says it runs natively. anyone having similar issues or seen a fix for this? i'll be happy to supply more info. Note: i do not see this in /etc/path_to_inst. so it looks like... (1 Reply)
Discussion started by: pupp
1 Replies

8. Solaris

stack space in sol10

we have a solaris 10 box (V440) we are looking for a way to set the stack size for all processes on the system. we know we can use ulimit -s $ ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 8192 coredump(blocks) unlimited... (2 Replies)
Discussion started by: robsonde
2 Replies

9. UNIX for Advanced & Expert Users

Compiling of MySQL 3.23 Solaris 8 x86 ( 07/01) faild (Please help)

I got the source tarbal from mysql.com of the latest version about 3.23. When I compile it, I get some errors of assembler etc. I start ./configure with these settings CC=gcc CFLAGS="-O6" \ CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure... (1 Reply)
Discussion started by: mrsaint
1 Replies
Login or Register to Ask a Question
MYSQL_TZINFO_TO_S(1)					       MySQL Database System					      MYSQL_TZINFO_TO_S(1)

NAME
mysql_tzinfo_to_sql - load the time zone tables SYNOPSIS
mysql_tzinfo_to_sql arguments DESCRIPTION
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X. One likely location for these files is the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a zoneinfo database, you can use the downloadable package described in Section 9.6, "MySQL Server Time Zone Support". mysql_tzinfo_to_sql can be invoked several ways: shell> mysql_tzinfo_to_sql tz_dir shell> mysql_tzinfo_to_sql tz_file tz_name shell> mysql_tzinfo_to_sql --leap tz_file For the first invocation syntax, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program. For example: shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. mysql processes those statements to load the time zone tables. The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name: shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql If your time zone needs to account for leap seconds, invoke mysql_tzinfo_to_sql using the third syntax, which initializes the leap second information. tz_file is the name of your time zone file: shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql After running mysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone data. COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/). MySQL 5.1 04/06/2010 MYSQL_TZINFO_TO_S(1)