6

How does mysql determine the hostname of its clients?

view full story
linux-howto

http://serverfault.com – I'm trying to create a MySQL user which will only be allowed to connect to the MySQL database from a specific hostname. grant all on db_name.* to 'user_name'@'appserver-lan.mydomain.com' identified by 'some_passwd' By checking the user table on the mysql db, I can see that the user was created successfully: use mysql; select * from user where User='user_name' and Host='appserver-lan.mydomain.com' or show grants for 'username'@'appserver-lan.mydomain.com' The hostname I specified is an alias to an amazon-ec2 name, which when resolved by the AWS DNS (HowTos)

grtyyu's picture
Submitted by grtyyu on 02/23/2012 – Made popular on 02/23/2012

Stories similar to How does mysql determine the hostname of its clients?

MySQL is failing to connect 1 year 17 weeks ago

I am building two mysql machines in master-slave config.

I have a mysql user connecting from Server2 to Server1 over SSL (mysql 5.0.77).

Here is the grants for this user on Server1, (server2 has an ip in the range xx.xx.xx.%)

mysql> show grants for user@'xx.xx.xx.%'; +-------------------------------------------------------------------------------------------------------------------------------+ | Grants for user@xx.xx.xx.%

How to create tables in MySQL 2 years 24 weeks ago

Our Tuesday MySQL tip, how to create Tables in a MySQL Database. Tables are somehow like spreadsheets, and one database may have lots of tables into it. So, once you have created your Database you may create the tables inside the Database. We’ll do it, working on the command line: First connect to the MySQL mysql -u [user] -p

This will ask the password for the user [user], it should be the

MySQL Workbech Wont Connect 2 years 43 weeks ago

I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:

Quote:

Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens

I have configured my MySQL Database to require passwords on all users, even root from the machine itself.

Now I discovered that there are empty Users in my Database

Reproduce: mysql -u root -p and then use mysql; & select * from user;

it gives me 2 entries, one with "localhost" and user and one with the machine's hostname and .

now i tried to access the account with mysql -u ' ' (yes it's

I'd like to create a new user in mysql which will be able to connect only from my servers. I've seen a way to do it through IP ranges or domain names (e.g. CREATE USER 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass'; )

Can I somehow (by changing hostnames, hosts files or such) define a domain of servers which talk to each other through this user, without involving a real DNS server?

My server hangs everyday

So i checked system health - process manager in whm

there was a command given below

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306

see this image

here this mysql command process is taking

MySQL process explanation 24 weeks 6 days ago

I have one MySQL process on my server running linux and it's always running it takes at least 50% usage of 1 Core (I have 8 cores)... This is process command:

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid

What this process is doing? This is not the issue just a question.

Hello all,

I'm trying to get ZoneMinder to run on a Fedora Core 17. I updated everything in the computer, then proceeded on manually creating the database, as it seems that ZoneMinder didn't create them automatically.