| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> 060201 15:32:12 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
<0> InnoDB: Error: log file .\ib_logfile0 is of different size 0 16777216 bytes
<0> InnoDB: than specified in the .cnf file 0 10485760 bytes!
<0> 060201 15:33:18 [ERROR] Default storage engine (InnoDB) is not available
<0> 060201 15:33:18 [ERROR] Aborting
<0> 060201 15:33:18 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
<1> !kick winikeh
<0> sorry
<2> wrs: oh sorry, thought this was in a select. with show columns I don't think you can do more than one
<3> shabbs, nps :) i'll go cry in a dark corner now
<3> though actually, im being fussy. i could just get the whole table info and grab what i want from that..
<0> let me try again...
<0> http://hashmysql.org/paste/1385
<0> there we go
<2> winikeh: edit the my.cnf and comment out skip-innodb
<2> and change the log-file-size variable to 16 megs or whatever their sizes were before
<4> if i have two tables, business, and zipcode.. business has 'name', 'city' and zipcode has 'city','zipcode' .. but some citys have many zipcodes.. i want to return the first zipcode.. how cna I force the zipcode to be sorted?
<4> select name, city, zipcodes.zipcode from busiensses,zipcodes where business.city = zipcodes.city
<0> how do you comment out?
<0> and where is my.cnf stored
<4> ' is comment '
<2> the dir you installed in
<2> and # is comment
<4> oops :P
<2> ' is comment in vb :)
<5> my.ini on windows
<2> whatevrawr!
<6> shabbs : Thank you, binding to localhost workes. Is there a manual page describing all the options of my.cnf?
<2> !m multichil system variables
<7> multichil: (System Variables) : http://dev.mysql.com/doc/mysql/en/System_Variables.html
<2> there should also be...
<2> !man config file
<7> (Dealing with Problems Compiling MySQL) : http://dev.mysql.com/doc/mysql/en/Compilation_problems.html
<2> nope, not that one
<2> !man configuration file
<7> (Configuration File) : http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Config_File.html
<8> can anyone confirm/deny: are underscores in MySQL 4 usernames illegal?
<0> that makes the difference
<2> not that one either, guess not
<0> so the my.ini
<0> ok
<8> can anyone answer my question please?
<8> I've been trying to get this fixed for 2 hours
<8> :(
<9> !m username restrictions
<7> username: (Full-Text Restrictions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Restrictions.html
<9> !m kapowaz username restrictions
<7> kapowaz: Nothing found
<9> !google site:dev.mysql.com restrictions on user name
<7> site:dev.mysql.com restrictions on user name: http://dev.mysql.com/doc/maxdb/en/09/ab35406ee32e34e10000000a155106/content.htm
<9> !google site:dev.mysql.com restrictions on user name -MaxDB
<7> site:dev.mysql.com restrictions on user name -MaxDB: http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf
<8> that site seems to suggest that underscores are legal
<2> kapowaz: why not just try it with a username without a _ and see if it works, then you'll have your answer
<9> I'm pretty sure tye are
<8> I already have and it does
<8> I just can't understand why it'd be illegal
<8> it certainly works in MySQL 5
<8> but not on 4.0.12
<0> skip-innodb is already commented out
<8> what if I escaped it, I wonder?
<10> what command i need to use to add a valiue to a filed on a mysql tablke ??
<8> with \
<11> winikeh: do you want to use innodb?
<9> !m Extreminador INSERT
<7> Extreminador: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<0> I think so
<6> Is mysql5 ipv6 enabled btw?
<8> nope... doesn't like that
<8> what ****e
<0> I am setting up MySQL to use phpbb
<10> insert thnaks
<10> thanks SQL
<0> but I may learn and make my own stuff in the future
<9> I think the first character cannot be an '_' perhaps
<2> that'd be sweet
<8> sjrussel: it's not the first character, the username is 'hj_phpbb'
<2> !man restrictions
<7> (Full-Text Restrictions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Restrictions.html
<2> !man name restrictions
<7> Nothing found.
<2> !man naming
<7> (Choosing Which Version of MySQL to Install) : http://dev.mysql.com/doc/mysql/en/Choosing_version.html
<2> hrm
<8> I bet if I upgrade to MySQL 5 it'll be solved
<8> but I sure as hell ain't doing that tonight!
<8> it's 9pm here
<8> I set out making these minor changes at 7
<5> thats early
<8> what a bummer
<2> takes but a minute + dump/load data
<11> kapowaz: why do you think that isn't allowed?
<8> HarrisonF: why do I think that an underscore isn't allowed? God only knows
<8> I created another user called hjphpbb, same privs - works fine
<11> and what does god know?
<8> it doesn't at any stage tell me the username is illegal
<8> it just rejects it
<11> how and when does it reject it?
<0> any further help?
<8> every which way
<8> command line
<11> what message does it give?
<8> MySQL Query Browser
<9> did you use GRANT?
<8> access denied for hj_phpbb@localhost (using p***word: YES)
<11> how did you create the user?
<8> use grant how?
<9> try FLUSH PRIVILEGES
<8> tried flushing privs
<8> I created it with MySQL Administrator
<9> !m kapowaz GRANT
<7> kapowaz: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<9> ah
<8> but I've flushed privs anyway
<8> and still no joy
<9> are you sure you've got the p***word right?
<9> sure sure?
<8> besides, I created the other user the exact same way afterwards
<8> the only difference is the missing underscore
<8> it's for a phpBB forum and when I remove the underscore it starts to work
<8> so it's definitely something to do with that user
<12> how many signs has ur username?
<8> signs?
<12> letters
<8> 8
<12> mm i had some probs when trying to create user with more than 14 letters
<12> but 8 should be alright
<8> aye
<12> by the why for me it is possible to create usernames like: 'Dr. Alban'
<12> spaces are allowed
<0> I find it hard to believe that I have stumped everybody and nobody can answer any more of my questions
<2> winikeh: you need to add/modify the setting for the innodb_log_file_size variable to 16 megs ( from the looks of your error log)
<5> kapowaz use - instead
<8> archivist: alas I can't change the username on the remote host
<8> I can use whatever I want locally
<8> but if I want to be able to just upload the stuff and it work, it needs to be the same username locally
<8> otherwise I'll have to manually change the file every time I upload it
<8> hardly practical
<10> is what dir are the databases ?
<10> # /var/lib/mysql/* right ?
<0> and that will make it all work?
<2> winikeh: it might
<13> what data type should i use for inserting a byte array? eg, the contents of an image file
<2> blob
<12> kapowaz: i made the experience, that if there is any grant left for a user, althought the user is not in db, it is not possible to create that user
<2> but why are you storing an image in the database in the first place?
<13> why not?
<13> it's a very small image... ~3kb
Return to
#mysql
or
Go to some related
logs:
mount: block device /dev/sdc1 is write-protected, mounting read-only
#gimp
nm-applet how to add to panel dapper
#linux
cannot stop mysql ezpublish
godaddy #1045 - Access denied for user: '@%' (Using password: YES)
#web
euphonee fan
#fedora
mythtv fx6600
|
|