MYSQL :: Disable Remote Root Login

Root Login Only
I have tried to create additional users with GRANT and INSERT INTO (FLUSH PRIVILEGES) but every time I start the mysql client only with the root password can I successfully login.

How do I get it so I have to enter a specific user name then be prompted for password?

Login As Root
Im using a WAMP setup of winXP pro, apache 1.3.31, mySql 4.1.21community-nt, PHP 5.1.6 and phpMyadmin 2.9.0.2
during the install of mysql i set a root password and after setup i created a new user using a 'grant all' statement in the client console.
what i want to do is completely remove the root account and use the new superuser account i created. But - i cannot login with the new account; only as root with the root password
Any suggestions how i can stop mySql from forcing me to use the root account.

Allowing Remote Login
I have been using MySQL for awhile, and for the first time someone from
outside our portable /16 needs access to some tables. We have given them
the server IP address, the dB name, the port 3306, the root username, and
the password, but they still can't get access. Of course, no firewalls or
other things in the way.

Is it true that MySQL defaults to local access only, and to enable remote
access you must do something unusual with grants? If so, how would I do
this? (warning, we use the win version, but this question is not a
windows-only thing so it is topical for this list:-)

Remote MySQL Login With Os X
I need to access my MySQL server running on an os x (panther) machine remotely from another machine running os x. Ive enabled SSH in system preferences but i dont really know where to go from there. ive been tralling the web for a good while now and i cant really find any info to help me. I'd like to use a gui client to login like CocoaMySQL.

Forgotten Root Login.
I need help resetting my root login. I've lost my password. I've uninstalled MySQL and reinstalled it hoping that it would work and no luck. How do I go about doing this? I'm operating on OSX.

Root Login Problems
I'm not able to login to mysql via root... strange things are happening.

I type in mysql -u root and I get
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

So, follownig the tutorials on the mySQL website, I kill the process with
kill `cat /var/lib/mysql/linux.pid`

which stops the process just fine.

Then I start it back up like so:
mysqld_safe --skip-grant-tables &

And it starts up okay, the pid appears again in the subdir.

Then I can log in okay via
mysql -u root

However, then I try to reset the password via:
UPDATE mysql.user SET Password=PASSWORD('pwordhere') WHERE User = 'root';

okay fine that takes okay. I do a query with select, seems fine, do an exit to get back to my prompt.

type in mysql -u root...
and viola, same error appears,
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Root Login Can't See All Databases
When I login as -u root, only test database can be seen, not others which were seen the last time I logged in as root. All databases are there in the data folder and no passwords were changed; what could be causing this?

Having Root Login Problem With Sql5.0
I just install the FC6 on my machine and also install httpd ,php,mysql5.0.27,proftpd.now with mysql im trying to setting up the pass and user for my mysqladmin -u root password "new-password" im getting this error message
/*
ysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

infact i just try to login using mysql for resetting my password for

update mysql.user set password=password("NEW-PASSWORD") where user="root";
flush privileges;
quit

root but getting this anoying error

update mysql.user set password=password("*******") where user="root";ERROR 1142 (42000): UPDATE command denied to user ''@'localhost' for table 'user'

Code:

Root Login Does Not Work Correctly Without -h Option
For example, I would expect to be able to sign in by using.

mysql -u root -p

The above gives me accessed denied.

Now, I need to do.

mysql -h <hostname> -u root -p

It seems like a simple problem that I have not been able to solve by searching here and google.

Machine Name & IP Address Fails For Remote Admin Login
I've just set up 5.0 on both a desktop server and a laptop with an essentially default install using WinXP (brand new, naive user here!).

I find that when I use the Administrator Tool that I can only log into ServerHost: "localhost" using Username: "root" and the password I made. This is made worse as I can only hit the desktop from the laptop using Remote Desktop connection.

What I can't do is either use the WinXP machine name, or the IP address for the Serverhost. This becomes an issue for the laptop especially as the IP address can change (although this is accessed through a VPN, so the WinXP machine name might be used).

I am quite confused by the documentation regarding servernames, bindings, hostnames, etc.

Remote Root Connection
I am new here and I have a problem with configuring mysql. How can I set up mysql to allow remote root connections from a specific IP range?? Is this possible at all?

Remote Administrator For Root User
I have got linux server and I want to use Mysql Administrator with root user but it can't accept root user for remote connections how can I fix that or is there any way to do that?

Enable Root Access From Remote Machines?
I just setup MySQL5 on a Windows 2003 dedicated box and one of the last questions in the Instance Configuration Wizard had a check box labeled: "Enable Root Access From Remote Machines".

I did some research but could not figure out what that meant. I log on to my box using Remote Desktop so if I don't check this will I able able to have root access?

I am guessing this is a security issue. I want my box to be as safe as I can.

Here is how I have the MySQL config file setup (from the Instance Configuration wizard):

port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
default-character-set=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=49M
table_cache=256
tmp_table_size=52M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=103M
key_buffer_size=76M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_data_home_dir="C:/MySQL Datafiles/"
#skip-innodb
innodb_additional_mem_pool_size=4M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1524K
innodb_buffer_pool_size=148M
innodb_log_file_size=30M
innodb_thread_concurrency=8

Active Enable Root Access From Remote Machines
Who i can active the option "Enable root access from remote machines" in the files of configuration of mysql 5.

I Changed Root Password But I Can Not Login With Changed Password
I changed the password of root with
update user set password=password('newpassword')

Then I exited. But when I want to login again , it cannot authenticate the root
I should tell you that a hacker had changed my root password before. Because it was not encrypted before.

Disable Log
I can disable bin logs

SET SQL_LOG_BIN=0;

But How do I disable and then enable the slow and general query log?

Disable Replication
I've got a server that used to use replication but no longer has any slaves. To turn this off and stop generating the bin files, do I just need to comment out the bin-log command in the cnf file then restart?

Disable A Trigger
I have found a need to disable a trigger for a short period of time while executing a query. Rather than delete the trigger and re-create it later, I wanna disable trigger for the tabe and after the execution enable the trigger.

Disable Bell
how to disable that annoying warning bell in the command line version of mysql. I am using mysql 5 on windows at the moment. I really don't appreciate the world knowing that mysql returned an error.

MySQL Remote Backups - No Access To FTP Or Remote Command Line
I have a mySQL database located on a remote host's server. I would
like to schedule a task on my local Windows computer to retrieve a
backup/dump of this remote database.

I have contacted my host, and they indicated that the server is only
open to the Internet via mySQL. Therefore, even if I did have access
to that server's command line (which I don't) to create dumps via
mysqldump, I would not be able to retrieve via FTP.

Does anybody have any ideas as to how I can generate backup files from
my local computer through a local command-line interface? I have done
it through a GUI (DBTools), but I would like to have it done via DOS
batch, so that I can schedule it. Does anyone know of any mysql backup
GUIs with command line switches? Or can somebody recommend an
alternate means of getting a local backup?

Disable A Single Database
Hi everyone I was wondering if there was a way to disable a single
database with having to shutdown mysql or rename tables?

Disable -- User Option
I would like to use unix user names to login to mysql. If I create a mysql user xxadmin and leave the password empty other unix users can use the xxadmin with the --user option . How can I make sure that only the unix user xxadmin can login as mysql user xxadmin ?

Disable Privilege System
If I set skip-networking, what is the security risk if I also skip-grant-tables? Is there any performance benefit that might justify leaving the privilege system disabled?

This is a dedicated database that runs on the same machine that hosts the application that it supports.

Disable MySQL Logging
I was a bit surprised, when I saw that mySQL create a huge logs, entierly useless for my testing server purpose and since the machine is relatively (a lot, VIA C is nowhere near fast) slow, I looking for ways how to completely disable these unnecessary logging
It is a Win2k server with mySQL 4.1.15-nt :-)

PS. how to convince the service to use as default latin2 coding?
--default-character-set=latin2_czech_ci
Is mentioned into the guide, but the server did not accept it at all in properties and trying to set it into the ini file was undocumented and sometimes cause mySQL not to start + it still not working and use the damn utf8 crap, that kill the czech characters :(((

How To Disable Binlog For Specific Table
For security reasons, we need a single table (containing sensible information) to be excluded from going to binlog. I have found out as much, that I can use SET SQL_LOG_BIN = {0|1} to switch logging on/off per connection, but I would prefer if I could simply exclude the table all together. The table is a ENGINE=MEMORY type table btw.

Enable/Disable (toggling) Triggers
I want to ENABLE/DISABLE my triggers time to time based upon certain conditions multiple times. How can I do that in MySQL ?

How To Disable Unused Table Types
I only use MyISAM for all my web applications, and that should suffice for years to come, so I'm wondering how to disable all other data types from the server, so it starts as only capable of dealing with MyISAM tables.

What other benefits there are in doing so, apart from perhaps a greater memory saving?

Sometime ago I thought of using/experiment with InnoDB type but it's initial 10MB footprint and all the changes in the existing code to make it transactional are too much perhaps. I also read somewhere InnoDB requires alot more memory than MyISAM, server only has 1GB.

Disable And Enable A Foreign Key In Mysql 5
i have created primary key / foreign keys...but then when I am trying to change
the data later, i am getting error, now i want to disable the foreign key,
change my data, and enable it again

but i am unable to find the correct syntax for this.

How To Disable Auto Truncation Of Char Binary Column
Why is a single space truncated in the following example?

Leif

alter table CURRENCY
change column THOUSANDS_SEP THOUSANDS_SEP char(1) binary not null
, type=MyISAM

UPDATE CURRENCY SET THOUSANDS_SEP = ' ' WHERE NAME = 'SEK'

SELECT LENGTH(THOUSANDS_SEP) AS L FROM CURRENCY WHERE NAME = 'SEK'
Result: L = 0

Login
I'm having a problem and I guess it's something wrong with my MySql database. I have a website where users need to register in order to login.
Everything was working fine, but recently my webhost had some upgrade and my folder changed from "home2" to "home", but I'm not sure that this is the problem.
Now, the new accounts are not created. The register form works fine, and appearently the account is created, but if I click to My Profile the data I completed is not there. Only the password appears but it's not the password I completed in the register form, it's the password from my Database.I also uploaded the website to a different webhost, but when I try to access the homepage, it shows like I'm already logged in, although I didn't and at the profile page, again, only a password... the database password.

Login Box
I have a script that uses MySQL and for some reason the first time it loads per session I get the prompt box to login to MySQL? It seems to be a session based but is just weird any ideas what is causing this?

CANNOT LOGIN
The database is accessible just fine through PHP and works great. When typing "mysql" inside a putty console I get:
"-bash: mysql: command not found"

I used to type "mysql -u user -p -h localhost" to log in just fine. Now mysql is not found?

Can't Login To Database....
I've been having a bit of toruble with mysql. I am creating a new user w/ a passwords, granting privileges, and then attempting to login:

Can't Login To MySQL
I am preparing a new server (FreeBSD, MySQL 4.1.1) and I can't connect to the server. I was able to connect for a little while, and I set the root passwords and removed the guest accounts. Things were going fine until I shutdown mysql and restarted it a bit later (can't remember what exactly I did in the meantime). Code:

Password Login
i have a simple java code for a password login but it only allows one user name and password, do i need mysql to have more users and i also want a registration page.

ODBC: Login
This is kind off topic how to connect to ODBC.

<?php
$server = "real_dsn_server:3180";
$user = "root";
$password = "admin4";
$dbnameID="info";?>

<?php
$conn=odbc_connect($server, $user, $password);
$sql="SELECT * FROM $dbnameID";
$result=odbc_exec($conn,$sql);
echo "SUCCESS";?>

I got the following error:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in odbc_log.php on line 10

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in odbc_log.php on line 12
SUCCESS

Why is that? Even though I can DSN in control Panel>ODBC on windows XP Pro and it said successfully.

Login Mysql 4.1.8
I have Mysql 4.1.8 installed in my computer and when i try to login it give me a message like the text below:

===============================================================
C:PROGRA~1MySQLMYSQLS~1.1in>mysql -h locahost -u root
ERROR 2005 (HY000): Unknown MySQL server host 'locahost' (11004)

C:PROGRA~1MySQLMYSQLS~1.1in>mysql -h 127.0.0.1 t -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
================================================================

Login To MySQL
I've got PHP and MySQL installed, tests run good. But when I want to give a command the following error is printed:

Warning:
mysql_connect() [function.mysql-connect]: Access denied for user: 'mayadhiisa@localhost' (Using password: YES) in D:My DocumentsMy Virtual Websmysql_send.php on line 18
Database Selected:
Query: create database baandd
Results
Error 1044: Access denied for user: '@localhost' to database 'baandd'

Whatever I do, "I got access denied for user", Where can my settings or query be wrong?

Simple Login
this is so easy but i can't seem to ascertain what is wrong. i'm making a 'random quote' database. this is my php (ver 4.3.11);

<?php
$link = mysql_connect('localhost', 'root', 'calvin');
if (!$link) {
die('Could not connect to server : ' . mysql_error());
}

$db_selected = mysql_select_db('quotes', $link);
if (!$db_selected) {
die ('Could not connect to database : ' . mysql_error());
}
?>

why do i get the following er msg?

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:ArtizanrookhavenBHconnection.php on line 2 

Could not connect to server : Client does not support authentication protocol requested by server; consider upgrading MySQL client

Login Error
I am trying to login to mysql using the following:

C:mysqlin>mysql -h localhost -u root -p
Enter Password: *********

But I keep getting this error:
ERROR 1045: Access denied for user: 'root@127.0.0.1' (Using password: YES)

What is going wrong? I have set the password correctly.

Cannot Login At Mysql5
I just installed mysql5
I am able to connect to it using telnet and mysqladmin

But when I try to login the username or password is not correct.

I installed it with the installer and set a new password there.
I thought I would have set the password for the root user but that is not working.

Can someone tell me what user and password I should use when i login the first time ?

MySQL Login
Does anyone know why I CAN login to mysql from a shell but can NOT from a PHP app using the same user/pass?

Login Problem
New error message when I try to login:

MySQL Error Nr. 1130

Server side? I edited my.cnf commenting the line "bind_address=127.0.0.1" now I get this error.

Administrator Login
I am really new and I am having a problem logging into the Admin Tool. What is the username and password ? This is my first time trying to login.

Eventum Login
I've just installed eventum-1.6.1 on my server (WinNT4.0). All worked fine. Now I'd like to login.

Login Fail
wrong message:
ï¼ˆERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)ï¼‰

è®¾ç½®ROOTå¯†ç åŽï¼Œç™»é™†å¤±è´¥,è¯·é—®æ˜¯ä»€ä¹ˆåŽŸå› ï¼Ÿ

why login fail,after I set up root's password?

Disable Remote Root Login

I would like to keep root non password protected locally. And disable root login via phpmyadmin and other remote mamagement tools. For remote login I would have seperate users set up.