Create a MySQL user that can only read — perfect for analytics, reporting or connecting a read replica. Fill in the details and copy the SQL.
-- Create a read-only MySQL user (SELECT only — cannot modify data)
CREATE USER 'bequery_reader'@'%' IDENTIFIED BY 'YCZibAuzxnvw8MLxyQJn';
-- Grant read-only access to all databases
GRANT SELECT ON *.* TO 'bequery_reader'@'%';
FLUSH PRIVILEGES;Read-only by construction: this user can only run SELECT — it cannot insert, update, delete or change schema. Restrict the host to a specific IP for tighter security. Nothing here is sent anywhere; the SQL is built entirely in your browser.
A dedicated read-only user is the safest way to give a tool access to your database: it can run SELECTqueries but cannot change, delete or corrupt anything. It's the standard way to connect BI tools, reporting dashboards and replicas.
Restrict the host to the specific IP that will connect (instead of %) for tighter security, and give the user access only to the database it needs.
BeQuery connects with exactly this kind of read-only user, then clones your store to an isolated copy so reporting never touches production.
Start free