One user 2+ database

inertown · Post by **inertown** » Sat Mar 28, 2015 7:58 pm

how to let one mysql user have 2+ database? or create db user themselves?

userA > db1 + db2 + ....

Post by **skurudo** » Sat Mar 28, 2015 8:03 pm

With phpmyadmin .
In other database use privileges to add rights your user..

inertown · Post by **inertown** » Sat Mar 28, 2015 8:14 pm

skurudo wrote:With phpmyadmin .
In other database use privileges to add rights your user..

hi skurudo~

after adding privileges, FTP is not connecting.

after I add a db in CP, phpmyadmin show one user has two hosts, which are % and Localhost, is it normal?

after I restart server in CP, mysql is connecting failed. but it shows started in CP, I gotta restart mysql, thing works normal.

Post by **skurudo** » Sat Mar 28, 2015 8:20 pm

after adding privileges, FTP is not connecting.

It's very odd, what's in logs?

after I restart server in CP, mysql is connecting failed.

Why? What's in logs?

...what's parameters your vps/server?

inertown · Post by **inertown** » Sat Mar 28, 2015 8:23 pm

skurudo wrote:
after adding privileges, FTP is not connecting.
It's very odd, what's in logs?

after I restart server in CP, mysql is connecting failed.
Why? What's in logs?

...what's parameters your vps/server?

AWS ubuntu 14, where can i found logs?

Post by **skurudo** » Sat Mar 28, 2015 8:25 pm

/var/log
/usr/local/vesta/log

https://vestacp.com/docs/#config-log-lo ... ian-ubuntu

inertown · Post by **inertown** » Sat Mar 28, 2015 8:38 pm

[quote="skurudo"]/var/log
/usr/local/vesta/log

https://vestacp.com/docs/#config-log-lo ... ian-ubuntu[/quote

InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
150328 19:47:34 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
150328 19:47:34 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/ ... codes.html
150328 19:47:34 InnoDB: Could not open or create data files.
150328 19:47:34 InnoDB: If you tried to add new data files, and it failed here,
150328 19:47:34 InnoDB: you should now edit innodb_data_file_path in my.cnf back
150328 19:47:34 InnoDB: to what it was, and remove the new ibdata files InnoDB created
150328 19:47:34 InnoDB: in this failed attempt. InnoDB only wrote those files full of
150328 19:47:34 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
150328 19:47:34 InnoDB: remove old data files which contain your precious data!
150328 19:47:34 [ERROR] Plugin 'InnoDB' init function returned error.
150328 19:47:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150328 19:47:34 [ERROR] Unknown/unsupported storage engine: InnoDB
150328 19:47:34 [ERROR] Aborting

150328 19:47:34 [Note] /usr/sbin/mysqld: Shutdown complete

150328 19:47:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150328 20:10:39 [Note] /usr/sbin/mysqld: Normal shutdown

150328 20:10:39 [Note] Event Scheduler: Purging the queue. 0 events
150328 20:10:39 InnoDB: Starting shutdown...
150328 20:10:41 InnoDB: Shutdown completed; log sequence number 1676453
150328 20:10:41 [Note] /usr/sbin/mysqld: Shutdown complete

150328 20:10:45 [Note] Plugin 'FEDERATED' is disabled.
150328 20:10:45 InnoDB: The InnoDB memory heap is disabled
150328 20:10:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150328 20:10:45 InnoDB: Compressed tables use zlib 1.2.8
150328 20:10:45 InnoDB: Using Linux native AIO
150328 20:10:45 InnoDB: Initializing buffer pool, size = 128.0M
150328 20:10:45 InnoDB: Completed initialization of buffer pool
150328 20:10:45 InnoDB: highest supported file format is Barracuda.
150328 20:10:45 InnoDB: Waiting for the background threads to start
150328 20:10:46 InnoDB: 5.5.41 started; log sequence number 1676453
150328 20:10:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150328 20:10:46 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150328 20:10:46 [Note] Server socket created on IP: '0.0.0.0'.
150328 20:10:46 [Note] Event Scheduler: Loaded 0 events
150328 20:10:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150328 20:16:52 [Note] /usr/sbin/mysqld: Normal shutdown

150328 20:16:52 [Note] Event Scheduler: Purging the queue. 0 events
150328 20:16:52 InnoDB: Starting shutdown...
150328 20:16:53 InnoDB: Shutdown completed; log sequence number 1676453
150328 20:16:53 [Note] /usr/sbin/mysqld: Shutdown complete

150328 20:17:21 [Note] Plugin 'FEDERATED' is disabled.
150328 20:17:21 InnoDB: The InnoDB memory heap is disabled
150328 20:17:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150328 20:17:21 InnoDB: Compressed tables use zlib 1.2.8
150328 20:17:21 InnoDB: Using Linux native AIO
150328 20:17:21 InnoDB: Initializing buffer pool, size = 128.0M
150328 20:17:21 InnoDB: Completed initialization of buffer pool
150328 20:17:21 InnoDB: highest supported file format is Barracuda.
150328 20:17:21 InnoDB: Waiting for the background threads to start
150328 20:17:22 InnoDB: 5.5.41 started; log sequence number 1676453
150328 20:17:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150328 20:17:22 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150328 20:17:22 [Note] Server socket created on IP: '0.0.0.0'.
150328 20:17:22 [Note] Event Scheduler: Loaded 0 events
150328 20:17:22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

inertown · Post by **inertown** » Sat Mar 28, 2015 8:40 pm

User Host Password Global privileges Grant Action
admin_testing % Yes USAGE No Edit Privileges Edit Privileges Export Export
admin_testing localhost Yes USAGE No Edit Privileges Edit Privileges Export Export

after adding user in CP. there two user in phpmyadmin. is it normal? which one I might make right to privileges to?

the % one or the localhost one?

Post by **skurudo** » Sun Mar 29, 2015 2:58 pm

From logs I can see two problems

1) ibdata1 - this may be apc or mysql try to start twice - viewtopic.php?f=14&t=6861&p=20746&hilit ... ice#p20746

2) need to tune your config for cpu/memory usage of your server

Post by **skurudo** » Sun Mar 29, 2015 3:01 pm

inertown wrote:after adding user in CP. there two user in phpmyadmin. is it normal? which one I might make right to privileges to?

This topic wll help you:
http://serverfault.com/questions/565343 ... phpmyadmin

Vesta Control Panel - Forum

One user 2+ database

One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Re: One user 2+ database

Login • Register