Hi All,
I want to create a table that defaults to current_date and current_time.
I have:
CREATE TABLE `personalevent`(
`pevent` mediumint(10) NOT NULL,
`eventid` mediumint(10) NOT NULL,
`userid` mediumint(10) NOT NULL,
`username` varchar(10) NOT NULL,
`pa
!
-Jason
On Apr 29, 2009, at 1:20 PM, mark konetchy wrote:
Jason,
It looks like mysql is erroring out when you try to start it from
the command line. What does the error log say?
2009/4/29 Jason Todd Slack-Moehrle
OK, I have done this:
[r...@server1 ~]# mysqld_safe
A mysqld process
ysqld_safe --init-file=clouds.sql &
(or whatever the path to mysqld_safe is)
2009/4/29 Jason Todd Slack-Moehrle
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'XXX';
FLUSH PRIVILEGES;
Here is the command that I am executing:
[r...@server1 ~]# /etc/init.d/mysqld restart --init-file=~/cloudsql.sql
at I am doing wrong...
-Jason
On Apr 28, 2009, at 5:34 PM, mark konetchy wrote:
hey jason,
you need to restart the *server* with the init-file option, have a
look at:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
2009/4/28 Jason Todd Slack-Moehrle
I am trying to st
I am trying to start MySQL with --init-file but i get that it is an
invalid option. the 'man' page and --help dont help me decide what is.
Here is what I am doing:
r...@server1 ~]# mysql start --init-file = cloudsql.txt
mysql: unknown option '--init-file'
Thoughts?
-Jason
--
MySQL General M
Hi All,
CentOS 5.3
I installed MySQL Server via yum and started it.
I tried entering:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
But I get:
r...@server1 ~]# /usr/bin/mysqladmin -u root -h localhost password
mypassw
Hi All,
On OS X, I have some Obj-C that creates NSTasks to execute some sql
statements.
What do I deploy on the client to make this work for them? I want to
make it park of my package installer, but I dont know what pieces.
Thoughts?
-Jason
--
MySQL General Mailing List
For list archiv
Hi All,
I have a client that wants to insert data into a VarChar field that contains
commas. These are property addresses.
Example:
2966 Moorpark Ave, San Jose, CA, 95128
1 Infinite Loop, Cupertino, CA, 95
How can I allow this?
Thanks!
-Jason
--
mysql> select * from msg where Author=6213 and (Saved='s' or Saved='n')
order by ID;
Empty set (0.00 sec)
---
mysql> select COUNT(*) from msg where Author=6213 and (Saved='s' or
Saved='n') order by ID;
+--+
| COUNT(*) |
+--+
| 191 |
+--+
1 r
10 matches
Mail list logo
