Re: MySQL install on OS X Lion does not create root account
You showed us a link which explains how you uninstalled MySQL. Perhaps you could tell us how you installed it? IT would certainly shed some light on the subject. If you are using a pre-built package for OS/X, the issue is likely with the package. If you are installing from source, there is an initialization step you may have missed. - michael dykman On Tue, Nov 15, 2011 at 4:21 PM, Martin Mueller wrote: > I have been struggling with installing MySQL 5.5.17 on a Mac running OS > 10.7. My machine had 5.5.15 on it. > > I keep getting user denied access messages (Error 1045). I thought at > first it was a matter of a password not being flushed from a previous > installation and went through repeated install and uninstall routines, using > the instructions by Rob Allen at > (http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/) > . > > I also followed various instructions in the MySQL documentation for > resetting lost passwords. But the results persuaded me that the problem is > something else: the installer does not create a root account or a mysql > account in the user table. Thus the update command for resetting the root > password executes correctly but update 0 rows. And logging in with the > skip-grants-table lets you address some queries to the mysql user table. > > "Select count(user) from user" returns 0, as does "select user, password > from user." So it appears that the installation routine (from the disk > image) does not populate the user table with accounts from which you could > then perform other activities. > > Does anybody have any idea what is going on here or what I could be doing > wrong? > > > > > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL install on OS X Lion does not create root account
I have been struggling with installing MySQL 5.5.17 on a Mac running OS 10.7. My machine had 5.5.15 on it. I keep getting user denied access messages (Error 1045). I thought at first it was a matter of a password not being flushed from a previous installation and went through repeated install and uninstall routines, using the instructions by Rob Allen at (http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/) . I also followed various instructions in the MySQL documentation for resetting lost passwords. But the results persuaded me that the problem is something else: the installer does not create a root account or a mysql account in the user table. Thus the update command for resetting the root password executes correctly but update 0 rows. And logging in with the skip-grants-table lets you address some queries to the mysql user table. "Select count(user) from user" returns 0, as does "select user, password from user." So it appears that the installation routine (from the disk image) does not populate the user table with accounts from which you could then perform other activities. Does anybody have any idea what is going on here or what I could be doing wrong?
Re: how to check how big a database is
Thanks, this is really helpful. From: Peter Brawley To: mysql@lists.mysql.com Sent: Tuesday, November 15, 2011 12:41 PM Subject: Re: how to check how big a database is On 11/15/2011 2:10 PM, Angela liu wrote: > In mysql 5.0 ,how to check how big a database is? > > > Thanks See "Database size" at http://www.artfulsoftware.com/queries.php PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yyll2...@yahoo.com
Re: how to check how big a database is
On 11/15/2011 2:10 PM, Angela liu wrote: In mysql 5.0 ,how to check how big a database is? Thanks See "Database size" at http://www.artfulsoftware.com/queries.php PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Cleaning up old files
2011/11/14 18:01 +, Rob Tanner So what are those files and can I delete all but the most recent? And if you look up replication, as others already have said, you will find that the command "purge binary logs to 'mysql-bin.'" will do just that--if, as Harald hinted, you really _want_ replication, or at least the output needed for it. I wrote "reset master" by mistake: that clears out _all_ the binary logs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how to check how big a database is
In mysql 5.0 ,how to check how big a database is? Thanks
Re: PID and LOG file
mysqld_safe might not know where your config file is located. You can specify it's location at the command line with --defaults-file=file_name alternatively, you could specify the location of your log file thus: --log-error=file_name other options found at http://dev.mysql.com/doc/refman/5.1/en/mysqld-safe.html - michael dykman On Tue, Nov 15, 2011 at 7:31 AM, javad bakhshi wrote: > Hi, > > I am trying to install Mysql on linux which I don't have a root access. I > have done the folowing : > > 1. Download source files from http://dev.mysql.com/downloads/mysql/ and > un-tar thwm > 2. configure the instalation using ./configure as: > CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions > -fno-rtti" ; \ > ./configure --prefix=/bubo/home/h10/javad/scratch/mysql \ > --enable-assembler \ > --with-mysqld-ldflags=-all-static \ > --with-client-ldflags=-all-static \ > --with-mysqld-user=javad \ > > --with-unix-socket-path=/bubo/home/h10/javad/scratch/mysql/tmp/mysql.sock \ > --localstatedir=/bubo/home/h10/javad/scratch/mysql/share \ > --datadir=/bubo/home/h10/javad/scratch/mysql/data\ > --enable-thread-safe-client > > 3. execute ./bin/mysql_install_db > 4. execute bin/mysqld_safe & to run mysql. but at this point I get the > folowing error: > Starting mysqld daemon with databases from > /bubo/home/h10/javad/scratch/mysql/data > ./bin/mysqld_safe: line 394: /var/log/mysqld.log: Permission denied > ./bin/mysqld_safe: line 402: /var/log/mysqld.log: Permission denied > STOPPING server from pid file > /bubo/home/h10/javad/scratch/mysql/data/the.pid > tee: /var/log/mysqld.log: Permission denied > 15 13:14:18 mysqld ended > tee: /var/log/mysqld.log: Permission denied > > I don't know why I get this error since I have changed the my.cnf to > err-log=/bubo/home/h10/javad/scratch/mysql/data/the.log > pid-file=/bubo/home/h10/javad/scratch/mysql/data/the.pid > > > > > > Best regards, > Javad Bakhshi, > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Cleaning up old files
2011/11/14 18:01 +, Rob Tanner So what are those files and can I delete all but the most recent? And if you look up replication, as others already have said, you will find that the command "reset master" will do just that--if, as Harald hinted, you really _want_ replication, or at least the output needed for it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
PID and LOG file
Hi, I am trying to install Mysql on linux which I don't have a root access. I have done the folowing : 1. Download source files from http://dev.mysql.com/downloads/mysql/ and un-tar thwm 2. configure the instalation using ./configure as: CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ; \ ./configure --prefix=/bubo/home/h10/javad/scratch/mysql \ --enable-assembler \ --with-mysqld-ldflags=-all-static \ --with-client-ldflags=-all-static \ --with-mysqld-user=javad \ --with-unix-socket-path=/bubo/home/h10/javad/scratch/mysql/tmp/mysql.sock \ --localstatedir=/bubo/home/h10/javad/scratch/mysql/share \ --datadir=/bubo/home/h10/javad/scratch/mysql/data\ --enable-thread-safe-client 3. execute ./bin/mysql_install_db 4. execute bin/mysqld_safe & to run mysql. but at this point I get the folowing error: Starting mysqld daemon with databases from /bubo/home/h10/javad/scratch/mysql/data ./bin/mysqld_safe: line 394: /var/log/mysqld.log: Permission denied ./bin/mysqld_safe: line 402: /var/log/mysqld.log: Permission denied STOPPING server from pid file /bubo/home/h10/javad/scratch/mysql/data/the.pid tee: /var/log/mysqld.log: Permission denied 15 13:14:18 mysqld ended tee: /var/log/mysqld.log: Permission denied I don't know why I get this error since I have changed the my.cnf to err-log=/bubo/home/h10/javad/scratch/mysql/data/the.log pid-file=/bubo/home/h10/javad/scratch/mysql/data/the.pid Best regards, Javad Bakhshi,
Re: Select data from large tables
You might want to have a look at partitioning that table. It'll be a considerable downtime, but if done right it'll speed up a lot of your selects. - Original Message - > From: "Adarsh Sharma" > To: "mysql" > Sent: Tuesday, 15 November, 2011 11:39:41 AM > Subject: Re: Select data from large tables > > More than 20163845 rows are there and my application continuously > insert > data in the table. > daily i think there is a increase in 2.5 Gb in that table. > > Thanks > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Select data from large tables
More than 20163845 rows are there and my application continuously insert data in the table. daily i think there is a increase in 2.5 Gb in that table. Thanks Chris Tate-Davies wrote: How many rows is that??? On Tue, 2011-11-15 at 16:05 +0530, Adarsh Sharma wrote: Dear all, I have a doubt regarding fetching data from large tables. I need to fetch selected columns from a 90Gb Table & 5Gb index on it. CREATE TABLE `content_table` ( `c_id` bigint(20) NOT NULL DEFAULT '0', `link_level` tinyint(4) DEFAULT NULL, `u_id` bigint(20) NOT NULL, `heading` varchar(150) DEFAULT NULL, `category` varchar(150) DEFAULT NULL, `c_url` varchar(500) NOT NULL, `keywords` varchar(500) DEFAULT NULL, `dt_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `content` mediumtext, PRIMARY KEY (`c_id`), KEY `idx_url` (`c_url`), KEY `idx_head` (`heading`), KEY `idx_dtstamp` (`dt_stamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Now I need to select distict category from content_table of size 90Gb. Simple select command can take days to complete & I donot think creating index on that column is a good idea. Please let me know any ideas to do that. Thanks
Select data from large tables
Dear all, I have a doubt regarding fetching data from large tables. I need to fetch selected columns from a 90Gb Table & 5Gb index on it. CREATE TABLE `content_table` ( `c_id` bigint(20) NOT NULL DEFAULT '0', `link_level` tinyint(4) DEFAULT NULL, `u_id` bigint(20) NOT NULL, `heading` varchar(150) DEFAULT NULL, `category` varchar(150) DEFAULT NULL, `c_url` varchar(500) NOT NULL, `keywords` varchar(500) DEFAULT NULL, `dt_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `content` mediumtext, PRIMARY KEY (`c_id`), KEY `idx_url` (`c_url`), KEY `idx_head` (`heading`), KEY `idx_dtstamp` (`dt_stamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Now I need to select distict category from content_table of size 90Gb. Simple select command can take days to complete & I donot think creating index on that column is a good idea. Please let me know any ideas to do that. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org