#mysql
02 October 2007
Total 26 pages. You are browsing page 26/26.
First :: Prev :: [...] [22] [23] [24] [25] [26] :: Next :: Last
23:48 <****> this "ON UPDATE CURRENT_TIMESTAMP" was new to mew
23:49 <****> s/mew/me/
23:49 <****> me to...but the SP would have worked as well
23:49 <****> no
23:49 <****> it would force the people to use the SP
23:49 <****> that was not part of the plan ;)
23:49 <****> you should use SPs anyway. Otherwise people could override the modified
23:49 <****> they could
23:49 <****> but THAT stupid they arent
23:50 <****> but i cant suppose them to make a new SP anytime they make a new Table
23:50 <****> you should
23:50 <****> hahahah
23:50 <****> gimme this people and i hire them ;)
23:50 <****> still got one job open, actually i can hire 2-3 guys if i like
23:51 <****> (once again Getty and his impossible tasks :)
23:51 <****> hehehe
23:51 <****> 75,000, 4 weeks vac, 401K and you got me
23:51 <****> LOL
23:51 <****> 401K?
23:51 <****> retirement plan
23:51 <****> Eld: what do you mean do "charset utf8" in mysql? i type that from the mysql prompt to no effect (actually spits out an ERROR 1064)
23:52 <****> ah
23:52 <****> i can just offer bad paid, but overtime paid and profit sharing
23:52 <****> Eld: Maybe its "CHARSET SET UTF8" ?
23:53 <****> charset utf8
23:53 <****> Charset changed
23:53 <****>
23:53 <****> Well, I have to make more than my 65K that I make now
23:53 <****> spg2007: What version are you using?
23:53 <****> 4.x something
23:53 <****> spg2007: use the mysql-client, not phpmyadmin or php itself; just the client
23:53 <****> so, still think i should define SP as way to update/insert? ;)
23:53 <****> i dont have you! ;)
23:54 <****> yeah i'm in the client "mysql" prompt itself
23:54 <****> Rince: Hes actually doing that.
23:54 <****> ah, ok
23:54 <****> spg2007:
23:54 <****> :)
23:54 <****> spg2007: There is no charset support in 4, it can only do latin 1.
23:55 <****> yes...make a company standard for SPs that everyone should follow
23:55 <****> spg2007: This means you have utf8 stored in a latin1 table.
23:55 <****> I still have a serious problem that I need to get fixed...
23:55 <****> I am using Centos 4.5, mysql 5.0.48 and php 5.0.22. I am having a problem where phpMyAdmin can connect to the database using root, but I cannot connect to mysql using command line or another php script. I reset the password many times and also re-installed mysql. Any ideas how this would happen? Oh, and I copied and pasted the password from the phpMyAdmin config file into my command line and still not working.
23:55 <****> ELD: ok thanks thats useful info... so next questions is should i be worried that the string is stored in the db with this weird encoding (even though it renders ok in a webapp)?
23:56 <****> Holzberg: do you try to connect as root@localhost?
23:56 <****>?
23:56 <****> mysql -u root -pXXXX
23:56 <****> spg2007: This is not a java app?
23:57 <****> Eld: no, its a Ruby on Rails app
23:57 <****> Rince: still not working
23:57 <****> it is so wierd
23:57 <****> Holzberg: but how do you know the usual password?
23:58 <****> spg2007: Is it a small amount of data?
23:58 <****> I set the password to the mysql root user using the disable grant option
23:58 <****> Holzberg: but _disable_ means that you take privileges away?
23:59 <****> Eld: well my DB is large. Nearly a million entries. Some of the usernames have these non-standard characters. So i want to make the app works ok if someone searchs on those weird characters
23:59 <****> spg2007: If it is a small amount of data and _all_ data is utf8 stored as latin1 its OK.
23:59 <****> Holzberg: you still have access to the mysql-system via phpmyadmin?
23:59 <****> This is only for root. I can login to any other user using the command line BUT root. The same goes for php scripts with the exception of phpMyAdmin which is the only thing I can use to login as root
23:59 <****> Rince: yes
23:59 <****> Holzberg: why do you want to use the login root and not another one? ;)
--- Log closed Wed Oct 03 00:00:09 2007
Total 26 pages. You are browsing page 26/26.
First :: Prev :: [...] [22] [23] [24] [25] [26] :: Next :: Last