--- Chris <[EMAIL PROTECTED]> wrote:
- snip -
> Try this:
>
> mysqladmin -u root password xyz
>
> That will change your password to 'xyz'.
>
Before received this email I tried;
[EMAIL PROTECTED] ~]# mysqladmin -u root -p
mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-linux-gnu on x86_64
Co
satimis wrote:
Typing either "mypassword" or "YES" prompted;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
* end *
That is asking for your *old* password.
[/quote]
I did not create password before. This is a new
--- Chris <[EMAIL PROTECTED]> wrote:
>
> > Retried as follows;
> >
> > [EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
> > Enter password:
> >
> >
> > Typing either "mypassword" or "YES" prompted;
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denie
> Typing either "mypassword" or "YES" prompted;
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: YES)'
> * end *
That is asking for your *old* password.
[/quote]
I did not create password before. This is a new installati
Retried as follows;
[EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
Enter password:
Typing either "mypassword" or "YES" prompted;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
* end *
That is ask
Hi Maciej,
I found that I made a mistake from the beginning
# mysqladmin -u root password yourrootsqlpassword
leaving out "--" before "password"
Retried as follows;
[EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword
Enter password:
Typing either "mypassword" or "YES" prompted;
> It makes no sense to use a default value with an auto_increment
> attribute, which means, the default value is the auto-incremented
> value.
>
> Carlos
Hmmm... I see your point. I sort of figured that the default was an
initial value, and from there, it incremented when accessed.
Sort of weir
It makes no sense to use a default value with an auto_increment
attribute, which means, the default value is the auto-incremented value.
Carlos
Al Sparks wrote:
I'm trying to install ProBIND, and I'm running mysql 4.1.20.
One of the ProBIND install scripts calls for tables to be created in
I'm trying to install ProBIND, and I'm running mysql 4.1.20.
One of the ProBIND install scripts calls for tables to be created in MySQL, and
I've culled it down to this:
mysql> CREATE TABLE zones (
-> id INT(11) DEFAULT '1' NOT NULL AUTO_INCREMENT,
-> PRIMARY KEY (id)
Hello All.
We have replication setup thus:- Master A --> Slave B. Now, the data
center will like to implement ca-unicenter on server-A and do some
testings for automation purpose. You've guessed it, Mysql-A will be
up-and-down for the next couple weeks. To provide business continuity, I
have be
I'm sorry, currentreturnrownum() doesn't exist .. I was looking for a
function like that so I can make a result set show what row it is in the
return set.
so I can get select currentrownumber , * from anytable;
then I get
1 (rest of date from the *)
2 (rest of date from the *)
3 (rest of date
This may sound mundane, but why not use a subselect COUNT?
SELECT COUNT(
select concat('Test row ',currentreturnrownum()) as testdata ,
mytestdata from mytestdatatable;) FROM mytestdatatable;
(I can't test this as I don't have currentreturnrownum() and cannot
Hi Maciej,
[quote]
Try running mysqld_safe with additional
parameter: --log-error=/var/lib/mysql/my.err. Then check what has been
written into that file.[/quote]
[EMAIL PROTECTED] ~]# kill `cat /var/run/mysqld/mysqld.pid`
No complaint
[EMAIL PROTECTED] ~]# /etc/init.d/mysqld restart
Stopping
sounds like a good solution.
regards
anandkl
On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote:
In news:[EMAIL PROTECTED],
"Ananda Kumar" <[EMAIL PROTECTED]> wrote:
> What i meant to say was. Say if i have two database A & B, and if i
> want to move only database A, then the shared tab
In the category of terrible, horrible, no good, very bad (but at least
documented) software behavior, I bumped into this today:
http://bugs.mysql.com/bug.php?id=14770
where the LOAD DATA INFILE command does not respect the default value of a
column if no value is supplied in the file. Instead, it
Has anyone found a way to get a result set with the current row return
number in a select statement without using vars?
select concat('Test row ',currentreturnrownum()) as testdata , mytestdata
from mytestdatatable;
++---+
|Test row 1 | testd
In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables &
> [1] 5119
> [EMAIL PROTECTED] /]# Starting mysqld daemon with databases from
> /var/lib/mysql STOPPING server from pid file
> /var/run/mysqld/mysqld.pid 070328 19:39:12
In news:[EMAIL PROTECTED],
"Ananda Kumar" <[EMAIL PROTECTED]> wrote:
> What i meant to say was. Say if i have two database A & B, and if i
> want to move only database A, then the shared tablespace will also
> have info about database B, and when i try to open the database A in
> the new machine,
Hi Maciej,
What i meant to say was. Say if i have two database A & B, and if i want to
move only database A, then the shared tablespace will also have info about
database B, and when i try to open the database A in the new machine, will
it not throw any error, saying that database B is not present
Okie, but in this case, if the shared tablespace has other database, then i
will be moving that also, which i may not require.
regards
anandkl
On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote:
On Wed, 28 Mar 2007, Ananda Kumar wrote:
> Hi Maciej,
> When you say copying binary Innodb d
On Wed, 28 Mar 2007, Ananda Kumar wrote:
Hi Maciej,
When you say copying binary Innodb data.
Can you please elobrate on this.
I meant the .ibd files, shared tablespace files, and so on.
Maciek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Depending on the version you use MySQL will see a definition of
varchar(25) as 25 bytes or 25 characters. I believe this changed from
4.1 to 5.0 respectively but I am not sure.
THis could be the root of the problem
Boyd
CONFIDENTIALITY NOTICE: This email & attached documents may conta
Hi Maciej,
When you say copying binary Innodb data.
Can you please elobrate on this.
regards
anandkl
On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote:
On Wed, 28 Mar 2007, Ananda Kumar wrote:
> Hi Maciej,
>
> Thanks a lot for this info, so the best may to move tables from one db
to
>
Hi Maciej,
[quote]
See the error log for details of why the server stopped. It is usually
located either in /var/log (or its subdirectories, such us /var/log/mysql)
or in mysql data directory, which in your case is /var/lib/mysql. The error
log filename pattern is 'something.err' (hostname.err
On Wed, 28 Mar 2007, Ananda Kumar wrote:
Hi Maciej,
Thanks a lot for this info, so the best may to move tables from one db to
another db on a different machine is to use mysqldump, right?
Not necessarily, especially if you are moving to a fresh, empty server.
Each solution has its advantage
In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables &
> [1] 5119
> [EMAIL PROTECTED] /]# Starting mysqld daemon with databases from
> /var/lib/mysql STOPPING server from pid file
> /var/run/mysqld/mysqld.pid 070328 19:39:12
Hi Maciej Dobrzanski,
This is a new installation. I'm now tuning MySQL.
[quote]
Try looking in standard directories such as:
/var/run/mysqld or /var/run/mysql or /var/run
The filename can be in form of 'hostname.pid', but it will rather be named
'mysqld.pid'.
[/quote]
[EMAIL PROTECTED] /]# l
Hi Maciej,
Thanks a lot for this info, so the best may to move tables from one db to
another db on a different machine is to use mysqldump, right?
regards
anandkl
On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote:
In news:[EMAIL PROTECTED],
"Ananda Kumar" <[EMAIL PROTECTED]> wrote:
> I
In news:[EMAIL PROTECTED],
"Ananda Kumar" <[EMAIL PROTECTED]> wrote:
> Is it possible for me to move all these files to a new db on a new
> machine. If you can you please let know how it can be done or guide
> to any url, it would be of great help.
You cannot do this with copying .ibd files alone
In news:[EMAIL PROTECTED],
satimis <[EMAIL PROTECTED]> wrote:
> Pls advise how to locate mysql=E2=80=99s hostname.pid file?
Try looking in standard directories such as:
/var/run/mysqld or /var/run/mysql or /var/run
The filename can be in form of 'hostname.pid', but it will rather be named
'mysq
Hi Friends,
This iddata datafile will be used by mysql to store internal data dictionary
information. You cannot have a mysql db with only without these files.
regards
anandkl
On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote:
In news:[EMAIL PROTECTED],
Nico Sabbi <[EMAIL PROTECTED]> wr
Hi Friends,
I have set innodb_file_per_table option in my.cnf file for one database.
Now there is huge load on this servers.
Is it possible for me to move all these files to a new db on a new machine.
If you can you please let know how it can be done or guide to any url, it
would be of great help
In news:[EMAIL PROTECTED],
Nico Sabbi <[EMAIL PROTECTED]> wrote:
> in /etc/my.cnf I set innodb_file_per_table in order to avoid a
> centralized set of ibdata* files,
> but that file (8 MB) is still present and continually updated.
> What can I do to make it vanish for good?
As it is stated in t
Hi,
As I know, master will replicate all database to the slave in
default. If I want to replicate only specified database, we can use
parameter in master.
binlog-do-db=databasename
I found that we can also use parameters to replicate database even
table in slave.
replicate-do-db=db_name (repli
Hi,
in /etc/my.cnf I set innodb_file_per_table in order to avoid a
centralized set of ibdata* files,
but that file (8 MB) is still present and continually updated.
What can I do to make it vanish for good? I'd like to have only
per-table ibd files.
The version of Mysql that I'm using is mys
Hi folks,
CentOS 4.4 amd64
I have been stuck on creating root password;
# mysqladmin -u root password yourrootsqlpassword[code]
Access denied for user ‘root’@'localhost’ (using password: NO)
[/code]
# su -
did not help.
Pls advise how to locate mysql’s hostname.pid file?
Then to run;
# kill
This helped:
http://forums.mysql.com/read.php?26,133157,136626
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I tried to set a replication as below.
S1(master) ---> S2 (slave), (master) --> S3 (slave)
I have set S1 and S2 (slave) without problem. However, there is a
problem in S2 as a master.
I found the the position in "show master status" also keep as 98 but I
am sure the replication from S2 to S1
Hi
when I execute
mysql> show slave status\G
I see this:
...
Last_Errno: 1175
Last_Error: Error 'You are using safe update mode and
you tried to update a table without a WHERE that uses a KEY column' on
query. Default database: 'xxx'. Query: 'delete from xxx
39 matches
Mail list logo
