mysql配置外网权限 好久不用都忘记了，这次再整理一下，方便以后查找。查看所有用户：SELECT user, host FROM mysql.user;查看特定用户的权限：SHOW GRANTS FOR 'username'@'hostname';查看用户的连接信息和权限：SELECT user, host, authentication_string FROM mysql.user;查看当前登录的用户：SELECT USER();查询所有用户的权限信息，使用以下命令：SHOW GRANTS;使用以下步骤来创建用户并授权外网访问：使用root用户登录到MySQL服务器上。如果尚未设置root密码，请使用以下命令更改或设置root密码：ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';创建新用户并授予外网访问权限。假设要创建一个名为new_user，允许从任何主机（'%'）访问数据库，并设置密码为user_password，可以使用以下命令：CREATE USER 'new_user'@'%' IDENTIFIED BY 'user_password';授予新用户对数据库的访问权限。例如，如果希望new_user用户有SELECT, INSERT, UPDATE和DELETE权限：GRANT SELECT, INSERT, UPDATE, DELETE ON database_name.* TO 'new_user'@'%';替换database_name为实际数据库的名称。刷新权限使更改生效：FLUSH PRIVILEGES;

解决Edge浏览器提示“此网站已被人举报不安全” 1月29日下午开始，大量用户反馈通过Edge浏览器的必应搜索百度内容时，会提示“此网站已被人举报不安全”，估计是Microsoft Defender SmartScreen 的库出问题了。直接关闭Microsoft Defender SmartScreen https://img-blog.csdnimg.cn/direct/28a39261640c498395f92177641bf80c.png

Ivory Coast celebrates oil find as west turns away from fossil fuels 　　Ivorians celebrated when Italian energy group Eni revealed that it had discovered up to A 2bn barrels of oil in waters off the west African country’s coast — the first big find in two decades.Ivorians celebrated when Italian energy group Eni revealed that it had discovered up to 2bn barrels of oil in waters off the west African country’s coast — the first big find in two decades.“It’s a great discovery,” said Abdourahmane Cissé, secretary-general of the Ivorian presidency, of last month’s find. “The preliminary results show that, in terms of oil reserves, it is approximately 10 times what we have at the moment,” he said, referring to initial estimates of between 1.5bn and 2bn barrels of oil as well as between 1.8tn and 2.4tn cubic feet of associated gas.Oil could start flowing within four years, boosting exports from a country that is already the world’s biggest grower of cocoa. “This will be good for the country,” said Cissé.But not everyone shares his confidence. Ivory Coast has struck oil just as much of the developed world has begun to call time on fossil fuels and some financial institutions are reluctant to take carbon-emitting projects on to their balance sheets.“People say: ‘We’ve found oil, we’ve found gas, we’re all going to get rich’,” said Kingsmill Bond, an energy strategist at think-tank Carbon Tracker. “But getting involved in extraction of fossil fuels is much riskier than it used to be and much riskier than it is perceived to be.”While Ivory Coast is already pumping small quantities of oil, Bond said the risk was that it would bring more “on stream at a time when the market is already in decline”. As advanced economies made the switch to electric vehicles and moved rapidly to renewable energy, demand for oil would fall and only the lowest-cost producers would survive, he added.Production costs of offshore African oil, especially in deep water, were relatively high, Bond said. Ivory Coast’s discovery is at about 1,200 metres. Despite the surge in oil and gas prices this autumn, many analysts argue that declining demand will eventually force prices down, making higher-cost oil uncompetitive.‘We’re not the polluters, the others are’The Ivorian find also taps into a broader debate about what it is reasonable to expect of developing countries that are reliant on fossil fuels.As the COP26 UN climate change summit in Glasgow approaches and many rich countries accelerate their shift towards clean energy, some governments in Africa — particularly hydrocarbon producers such as Nigeria and Equatorial Guinea — are calling for a “just energy transition” that allows for a slower switch to other fuels.Governments in Africa, which are responsible for at most 3 per cent of global emissions, object to being pressured by banks and donors to abandon the fossil fuels on which they say their industrialisation and development depends. Many, including Ghana, Senegal and Mauritania, are only now gearing up their hydrocarbon production.“We’re going to do what is in the interests of our country,” said Alassane Ouattara, president of Ivory Coast, in an interview, adding that Abidjan intended to exploit its hydrocarbons for the benefit of its people.Countries such as the US, where carbon emissions were nearly 40 times higher per capita than in Ivory Coast, were in no position to lecture, he said. “We are not the polluters. The others are,” he added.Powering the nation: ‘We will need gas’Alessandro Puliti, Eni’s chief operating officer for natural resources, said the Ivorian discovery met the Italian company’s criteria for investment. This was partly because the associated gas could be fed into existing infrastructure that already supplied Ivory Coast with 60 per cent of its electricity, he said.In Ivory Coast, a relatively high three-quarters of people have electricity and it has one of west Africa’s most reliable power grids. It exports electricity to Ghana, Mali, Benin, Togo and Burkina Faso.Energy minister Thomas Camara said that by 2030 the Ivorian government intended to increase the mix of renewable energy — currently entirely hydro — from 40 per cent to 42 per cent of a much larger energy pie.There were plans to add solar, including from a floating solar farm on a lake, as well as biomass energy made from waste in the palm oil and cocoa industries, he said. “But we envisage our energy needs will go up significantly by 2030 and for that we will need gas.”Africa without oil?There was a danger the world was transitioning towards green energy without taking into account the huge development needs in Africa and other poorer regions, said Kenny Fihla, chief executive of wholesale clients at Standard Bank, Africa’s biggest lender.Older petrol and diesel vehicles would be on the road much longer in Africa, where most countries relied on second-hand imports for the bulk of their fleet, he added.　　“It is nearly impossible to talk about Africa without oil at this stage,” he said. “Even in 2050, there will still be some oil utilisation, as other types of fuel will not have developed adequately to be able to replace it.”Bond from Carbon Tracker urged African governments to look with more urgency at developing solar and wind power which, he said, would prove to be both more abundant and cheaper than fossil fuels.“The way I see it, it is really daft to advise people to invest in the dying technology of fossil fuels when we ourselves are moving to far superior renewable technologies,” he said. “Africa missed out on the fossil fuel-driven energy system and all the wealth that flowed from that. But they don’t need to miss out on this one.”Still, in the interim, Ivory Coast was not about to let its big oil find go to waste, said Cissé. Asked if he thought developers would have any difficulty with securing bank lending to develop the oilfield, he said: “Now they’ve found it, trust me, there won’t be any issues of financing.”

Text 1 　In the silent ticket office, beneath the half-moon windows of the booths, a large green sign announces “OKEHAMPTON” to an empty room. On the platform, a faded poster reads "DEVON-Travel by rail". Those reading it have had little chance to do so. The last passenger train left Okehampton on June 3rd 1972. The town turned out to mourn: the mayor stood by, holding a wreath. On the line, between the sleepers, the grass started to grow. 　But Okehampton is changing. New steel tracks gleam beneath the platform; diggers toil in the car park. The station is being reopened as part of the government's "Restoring Your Railway" fund, launched in January last year to keep a manifesto promise. Okchampton is the first to reopen.Eleven miles of track have been laid in four weeks. 　In 1963 a report by Richard Beeching. chairman of the British Railways Board, earmarked 5,000 miles of track and 2,363 stations for closure. To this day, it is seen less as a piece of bureaucracy than as an act of “infamy"; it cuts "a wound that hasn't healed", according to Stewart Francis, a former chairman of the Rail Passengers’ Council. On the Beeching "wound”, Okehampton's 11 miles of shiny new track are a mere sticking plaster. 　But to see this in terms of pure numbers is to miss the point. More than sleepers and steel were lost. "Railways have a strange position in the British mind,” says John Preston. a professor of rail transport at the University of Southampton. “A lot of rural lines disappeared that were representative of a way of life...for which there was a lot of nostalgia," he notes. The new line is less about travelling through Devon than about travelling through time. 　While lots of infrastructure is prosaic, in Britain trains become poctry, their lines not just crossing the land, but running on into the litcrature of Robent Louis Stevenso, John Betjeman and W.H.Auden. Restoring railways nods to this fictional Britain, a place of branch lines and straight backs, railway porters and station masters. 　But poetry, while nice, has never been particularly profitable. There could hardly be a worse time for them to open: in the first COViD-19 lockdown passenger numbers fell by around 90% and "the post-COVID demand path is not yet clear", says Mr. Preston. Stil, in Okchampton the locals seem pleased. Becky Tipper, the Network Rail manager in charge of the rcopening, was surprised when, as her workers started laying the track, “a crowd of people" turned out once again. This time, no wreaths. Instead, says Ms. Tipper, they started clapping.

安装面板 CentOS安装脚本 yum install -y wget && wget -O install.sh http://download.bt.cn/install/install_6.0.sh && sh install.sh 9f453aec8eUbuntu/Deepin安装脚本 wget -O install.sh http://download.bt.cn/install/install-ubuntu_6.0.sh && sudo bash install.sh 9f453aec8eDebian安装脚本 wget -O install.sh http://download.bt.cn/install/install-ubuntu_6.0.sh && bash install.sh 9f453aec8eFedora安装脚本 wget -O install.sh http://download.bt.cn/install/install_6.0.sh && bash install.sh 9f453aec8e命令管理bt重启面板bt 1停止面板bt 2启动面板bt 3重载面板bt 4修改面板密码 （交互式，执行命令后回车输入新的面板密码即可，推荐密码规则：大小写字母，数字，特殊符号）bt 5修改面板用户名 （交互式，执行命令后回车输入新的面板用户名即可，推荐用户名规则：大小写字母，数字，特殊符号）bt 6修改数据库密码bt 7修改面板使用端口bt 8清除面板缓存bt 9清除面板登录限制bt 10取消域名绑定限制bt 12取消IP访问限制bt 13查看面板默认登录信息bt 14清理系统垃圾bt 15修复面板bt 16设置日志切割是否压缩 （默认开启，执行第一次bt 17是关闭日志压缩，再执行一次是开启日志压缩）bt 17设置是否自动备份面板 （默认开启，执行第一次bt 18是关闭面板自动备份，再执行一次是开启面板自动备份）bt 18显示面板错误日志bt 22关闭BasicAuth认证bt 23关闭动态口令认证bt 24设置是否保存文件历史副本 （默认开启，执行第一次bt 25是关闭文件副本功能，再执行一次是开启文件副本功能）bt 25关闭面板静态文件加速rm -rf /www/server/panel/plugin/static_cdn/ && bt restart开启面板离线模式echo "True" >/www/server/panel/data/not_network.pl关闭面板离线模式rm -rf /www/server/panel/data/not_network.pl && bt restart