Software Engineer at Tably Inc.
Google Developers Expert (Assistant, Web Technology)
๐ Lunakey Mini now on sale
ChromeMyAdmin provides you the administration GUI of MySQL server. It is like phpMyAdmin, Sequel Pro.
Home Page: https://www.eisbahn.jp/chrome_mysql_admin
License: Apache License 2.0
Software Engineer at Tably Inc.
Google Developers Expert (Assistant, Web Technology)
๐ Lunakey Mini now on sale
Is any support planned for multiple select rows and delete them over the keyboard keys delete etc.?
The same thing in the search box. Here it would be nice to hit enter and the search starts.
Great App =). I like it.
I like how the app shows the query it's currently running, but being able to read it before it goes away is difficult. It would also be nice to be able to copy the query before it disappears.
But displaying that message longer than necessary would not be good either. So maybe a query log or something similar would be nice. Somewhere to go that would show all the queries run on the server for the current session or all sessions?
Just a thought. Thanks for this app.
Your extension is very handy and too good... But..
After using for few times may be 4 or 5 times, if I click to open it, it never opens up and i need to uninstall it and install again. Please take a look.
Is there a way to export/import entire tables?
Unable to view all record data, can't scroll to last column of table.
I can see the comment column in the table structure section, but I do not know where I can write a comment for the table.
I can add / edit a new column, but I cannot see the column section in the add/edit layer.
This looks similar to #37.
I am using Chromium 57 + Linux. When I load the same SSH-based MySQL configuration that works correctly on my Chromebook Pixel (running ChromeOS), the application hangs forever with the message below.
This appears to be a JavaScript error, as when I open the extension console page I see the following right as I click "Connect":
I've updated the software to use the new "search on enter key" feature, but now it won't load at all.
When I open the app, it shows the basic layout (white screen with grey box where table list would be) but nothing else. No link to localhost, no information anywhere, no nothing. Just a white screen with a grey rectangular sidebar.
Please let me know if you need any more information, and I'm happy to provide.
v4.6.1
Chrome Version 48.0.2564.109 m
Windows 8.1
MySQL 5.6.26-log - MySQL Community Server (GPL)
Is it possible to collapse or resize the list of tables/views on the left hand side? Even by trick as a work around?
I am logged in as an administrator. I can create tables, but cannot add columns to them. Error is: [Error code:1146 SQL state:42S02] Table 'hswdb1.[object Object]' doesn't exist.
Tried this on multiple tables with the same result
,
frequently, the app can not connect to database.
I was migrating a (mostly empty) mySQL database from my old web host to my new.
My process was to 'export' the existing database and data, which generated a big sql file with many statements. I copy/pasted the contents of the file into the query view of 'Chrome MySQL Admin' and when I execute things, only the first dozen (or so) statements seem to execute.
The expected functionality would be to execute all statements. I ended up using the MySQL Admin client from Oracle to perform the task. I pasted the contents of the file in and it executed all statements created the database and restoring all the existing date.
I did not really see anything that mentioned a max number of statements or see anything in the config to control the number of statements.
Other than that, love the product.
create user 'ausername'@'%' identified by 'apassword';
Grant SELECT, INSERT, UPDATE, DELETE on aDatabase.aTable to 'ausername'@'%'
I expected these commands to execute successfully. But they yield an error:
[Error code:1064 SQL state:42000] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GRANT SELECT, INSERT, UPDATE, DELETE on aDatabase.aTable to 'ausername'@'%'' at line 2
However when I execute this command in mySQL workbench, they execute successfully.
Hi, my host enabled SSH to my remote server since I cannot access directly to the port 3306 but is does not work on my chromebook with your app, using it from my mac with Navicat Lite it does work the ssh tunnel. I dont know if you have the option why is not working ?
The app just says connecting to MySQL forever and never gives a message back.
thanks
I'm not sure here is the right place to report it.
I found the link to "Issue Tracker" in the bottom of https://www.eisbahn.jp/chrome_mysql_admin/ doesn't work:
I tried it on Chrome, Firefox, IE 11 on Windows, and both reproduced same bug.
,
It would be nice to have multiple tabs to manipulate different tables at the same time.
Hi there; great app. When enabling 'Allow NULL' on Timestamp datatype, the field is not saved with the selected NULL allowance.
Cheers.
When trying to edit a table record, either by double clicking on the record or clicking the pencil icon at the bottom the rows view, clicking the Update button does not do anything. Seems to not be working since version 2.14 or 2.15.
Thank you!
When connecting to Google Cloud SQL over SSL I receive the error "Connection failed. Incompatible TLS Version." Is there somewhere I can get more debug output to see why this would be true?
Adding intellisense in query editor can be a great feature for this product
Hello,
I am new into Google Cloud SQL and using Google Chromebook to connect to it.
I hope Chrome mySQL Admin very useful, since the Google provided tool is very primitive.
I tried to use the same connection details which i used in SquirrelSQL, but could not connect.
Could not find useful information from google (https://cloud.google.com/sql/docs/mysql-client#connect-no-ssl)
Please help, if possible.
Thanks.
Since the update, I'm no longer able to create and/or access favorite servers.
The list of favorite servers that I had before the update is gone, and I'm unable to create any new favorites. I'm not sure if it's creating them and I just can't see them, or if they are not being created.
Let me know if you need any other information.
Note: I get this in my console log for window.html:
extensions::platformApp:15 history.pushState is not available in packaged apps.
extensions::platformApp:15 history.state is not available in packaged apps.
When I press the connect button the app shows the following forever:
Now communicating with MySQL server...
Logging in to MySQL server.
Does anyone know how credentials are stored in this Chrome app?
Is everything local and secure or are they going to a server somewhere.
,
I am trying to use the SSH2-function with a private key. The same key works perfectly in sqlyog. There is no password so I guess it has to be the file format. What should it look like?
Version: 4.6.4
Full error message:
Port forwarding failed.
Unable to extract public key from private key file: Wrong passphrase or invalid/unrecognized private key file format -16
Adding a new row there doesn't seem to be a way to use NOW() for created_at/updated_at fields. I see I can use the 'Query' tab for this
INSERT INTO `users` (`id`, `username`, `email`, `password`, `bio`, `settings`, `created_at`, `updated_at`) VALUES ('4', 'bar', '[email protected]', 'helloinsecurepassword', 'I have no bio', '{}', NOW(), NOW())
Any plans on implementing the use of functions when entering values in the gui part?
Really cool app by the way.
I just want to make sure this app isn't calling home to give away all my credentials to my server. :-)
Thanks!
The following code can't be divided:
--
-- hoge
--
DELIMITER ;;
The code above will be one string... It should be two sentences...
,
When switch to database whos name contains -
, the app will give the flowling error:
Fatal error occurred. Go back to login screen.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-development' at line 1
Hi Yoichiro,
Have porblems with connection on azure.com as I've tested the connection to the base and it is ok, but your application wrote me -188 (TIME that the Connection timed up). Could you please advise what to do?
Thank you in advance.
,
Would it be possible to make the editing of data inline in the row's view? The modal for editing I personally find distracting and time consuming.
If a table storage binary file or image or something largger data, it will get stuck when select data from table.
Hope to be fixed.
Thanks!
When I edit a datetime field that has the structure to allow NULL it wont let me add a NULL in the value it will just default to the default datetime value. Great job so far, hope to see this app take off!
Would be great if my db user / pass would sync across Chrome when I login somewhere else. :)
I was trying to select some of the data in a result row and was unable to do so.
If I could select all the data in a single field, a whole row, or a whole result set, that would be awesome.
Thanks.
Can I increase font size in ChromeMyAdmin in Query tab or others?
Hi
There is a pagging problem.
I have 343 row of data in one of my table first time i choose that table show "1/3" second time i choose that table show "1/5".
sequel pro has some awesome built in functionality that allows you to preview columns with long text (long varchar, text, mediumtext ...) by rendering it as text or html. I am wondering if something like that should be added to this tool.
,
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.